![]() It’s a good practice to view the attributes of a column before modifying it. Here is the basic syntax for modifying a column in a table: ALTER TABLE table_name This statement shows the new structure of the vehicles table: DESCRIBE vehicles Ĭode language: SQL (Structured Query Language) ( sql ) MySQL ALTER TABLE – Modify columns 1) Modify a column To add multiple columns to a table, you use the following form of the ALTER TALE ADD statement: ALTER TABLE table_nameįor example, this statement adds two columns color and note to the vehicles table: ALTER TABLE vehicles This statement shows the column list of the vehicles table: DESCRIBE vehicles Īs shown clearly from the output, the column model has been added to the vehicles table. The following example uses the ALTER TABLE ADD statement to add a column at the end of the vehicles table: ALTER TABLE vehicles ![]() If you omit this clause, the column is appended at the end of the column list of the table. You can add a column after an existing column ( ATER column_name) or as the first column ( FIRST).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |