Question

Deleting columns A bank database has been created for you. USE the bank database and complete the following tasks using the mysql prompt: 1. Remove the cc_num (credit card number) column from the u_accounts table.

Answer 1

To remove the column from a given table following query can be used.

ALTER TABLE table_name DROP COLUMN column_name;

to remove multiple columns use following query

ALTER TABLE table_name

DROP COLUMN column_name1,

DROP COLUMN column_name2,

.........;

Here ALTER is used to modification in the table and DROP is used to remove or drop.

for above statement following query can be used.

ALTER TABLE u_accounts

DROP COLUMN cc_num;