Provider table Product table Product-provider table Make a query with the following rules (MySQL) 1). Change the data re

[answerhappygod]

Provider table

Provider Table Product Table Product Provider Table Make A Query With The Following Rules Mysql 1 Change The Data Re 1 (21.74 KiB) Viewed 22 times

Product table

Provider Table Product Table Product Provider Table Make A Query With The Following Rules Mysql 1 Change The Data Re 2 (20.9 KiB) Viewed 22 times

Product-provider table

Provider Table Product Table Product Provider Table Make A Query With The Following Rules Mysql 1 Change The Data Re 3 (27.99 KiB) Viewed 22 times

Make a query with the following rules(MySQL)
1). Change the data records in the "product" table that havenumbers B1, B2 and B3 the colors are changed to yellow, pink andgreen. For the weight plus 5 for B1, B2 and B3
2). Show providers and products residing in the same city
3). Displays the name of the provider that provides pinkgoods
Code-P Name-P Smith Jones Blake Clark Adams P1 P2 P3 P4 P5 Status 20 10 30 20 30 City London Paris Paris London Athens
Code-B Name-B B1 B2 B3 B4 B5 B6 Nut Bolt Screw Screw Cam Cog Colour Red Green Bleu Red Blue Red Weight City London Paris Rome London Paris London 12 17 17 14 12 19
Code-P P1 P1 P1 PI PI P1 P2 P2 P3 P4 P4 P4 Code-B B1 B2 B3 B4 B5 B6 B1 B2 B2 B2 B4 B5 Total 300 200 400 200 100 100 300 400 200 200 300 400