GoFuckYourself.com - Adult Webmaster Forum - View Single Post

QualityMpegs · 03-06-2005, 09:42 PM

Ok, for class I have to do some queries and I am totally lost here. Here's the tables:

Jobs: contains
jnum, jname, numworkers, city
I can only perform UPDATE on the "city" column on this table.

Parts: contains
pnum, pname, color, weight, city
I can only perform UPDATE on this table.

Shipments: contains
snum, pnum, jnum, quantity
I can only perform SELECT on this table.

Suppliers: contains
snum, sname, status, city
I can only perform INSERT on this table.

How would I go about doing these queries with those restrictions?

1-Insert into parts the row: P60, flange, silver, 8, Los Angeles.
2-Insert into shipments the row S5, P8, J5, 40.
3-Update the name of the part identified by key value P33 with the new name of gear.
4-Update the city value of the job identified by key value J3 with Dallas.
5-List all of the parts which are shipped in a quantity greater than 125.

03-06-2005, 09:42 PM
QualityMpegs Confirmed User Join Date: Feb 2003 Location: Orlando, Florida Posts: 3,521	MYSQL Query question Ok, for class I have to do some queries and I am totally lost here. Here's the tables: Jobs: contains jnum, jname, numworkers, city I can only perform UPDATE on the "city" column on this table. Parts: contains pnum, pname, color, weight, city I can only perform UPDATE on this table. Shipments: contains snum, pnum, jnum, quantity I can only perform SELECT on this table. Suppliers: contains snum, sname, status, city I can only perform INSERT on this table. How would I go about doing these queries with those restrictions? 1-Insert into parts the row: P60, flange, silver, 8, Los Angeles. 2-Insert into shipments the row S5, P8, J5, 40. 3-Update the name of the part identified by key value P33 with the new name of gear. 4-Update the city value of the job identified by key value J3 with Dallas. 5-List all of the parts which are shipped in a quantity greater than 125.