Computer scienceFundamentalsSQL and DatabasesDBMSMySQLData Definition Language

Alter table

Fix the typo

Report a typo

Select the correct query to fix the typo in the table customers with columns name (VARCHAR(20)), order_no (INT), and date (DATE).

nme

order_no

date

Select one option from the list

ALTER TABLE customers MODIFY COLUMN nme name VARCHAR(20);

ALTER TABLE customers CHANGE name varchar(20);

ALTER TABLE customers CHANGE nme name varchar(20);

ALTER TABLE customers ADD COLUMN name VARCHAR(20);

___

Create a free account to access the full topic