You are writing commnad statements based on the table shown below, as well as ot
ID: 3656579 • Letter: Y
Question
You are writing commnad statements based on the table shown below, as well as other tables in the General Hardware Company database. Use standard SQL syntax for the commands unless otherwise specified.
(d)PRODUCT table
PRODNUM PRODNAME UNITPRICE
16386 Wrench 12.95
19440 Hammer 17.50
21765 Drill 32.99
24013 Saw 26.25
26722 Pilers 11.50
PRODUCTS table
1. Assume that PRODNUM values are generate automatically. Write statemetns to add the following:
PRODNAME UNITPRICE
Bit 1.47
Torch 211.44
(d)PRODUCT table
PRODNUM PRODNAME UNITPRICE
16386 Wrench 12.95
19440 Hammer 17.50
21765 Drill 32.99
24013 Saw 26.25
26722 Pilers 11.50
Explanation / Answer
The data values supplied must match the column list. The number of data values must be the same as the number of columns, and the data type, precision, and scale of each data value must match those of the corresponding column. You can specify the data values in the following ways:
By using a VALUES clause to specify the data values for one row. For example:
For more information, see Inserting Rows by Using INSERT and Values.
By using a SELECT subquery to specify the data values for one or more rows, such as:
For more information, see Inserting Rows by Using INSERT and SELECT Subqueries
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.