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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!