Alter Table Command In Mysql. The ALTER TABLE statement is used to add delete or modify columns in an existing table. ALTER TABLE Statement This SQL tutorial explains how to use the SQL ALTER TABLE statement to add a column modify a column drop a column rename a column or rename a table with lots of clear concise examples.
Also it can be used to add modify or drop a column from an existing table. To use ALTER TABLE you need ALTER CREATE and INSERT privileges for the table. Using the command you can easily change the name of your table and columns add or delete columns or change the type of existing columns.
Mysql -u username -p.
This command is most often used with ADD DROP and MODIFY statements depending on the. Renaming a table requires ALTER and DROP on the old table ALTER CREATE and INSERT on the new table. ALTER TABLE newbook_mast ADD INDEX cate_idcate_id. The function that concerns us the most is how to utilize.
