Question: 4. Write an ALTER TABLE statement that adds two new columns to the productis in Exercise 1 Add a column for e product price that
4. Write an ALTER TABLE statement that adds two new columns to the productis in Exercise 1 Add a column for e product price that allows for three digits to the left of the decimal point and two to the right (max value of 999,.99). This cold have a default value of 9.99 hould Add a column for the date and time that the product was added to the database. 5. Write an ALTER TABLE statement that modifies the users table created in Exercise 1 e Set the last name column to allow NULL values and can store a maximum of 20 characters Write an update that inserts a NULL value into the last_name column where user_id 1 (this should now work). Write an update that inserts "Wolfeschlegelsteinhausenbergerdorff into the last _name column where user id - 1 (this should not work as it is longer than 20 characters)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
