{"id":13754,"date":"2023-12-29T00:56:02","date_gmt":"2023-12-29T07:56:02","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=13754"},"modified":"2023-12-31T02:26:45","modified_gmt":"2023-12-31T09:26:45","slug":"mysql-alter-table","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-alter-table\/","title":{"rendered":"MySQL ALTER TABLE"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL ALTER TABLE<\/code> statement to add a column, alter a column, rename a column, drop a column, and rename a table.<\/p>\n\n\n\n

Setting up a sample table<\/h2>\n\n\n\n

Let’s create a table<\/a> named vehicles<\/code> for the demonstration:<\/p>\n\n\n

CREATE<\/span> TABLE<\/span> vehicles (\n    vehicleId INT<\/span>,\n    year<\/span> INT<\/span> NOT<\/span> NULL<\/span>,\n    make VARCHAR<\/span>(100<\/span>) NOT<\/span> NULL<\/span>,\n    PRIMARY KEY<\/span>(vehicleId)\n);\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
\"MySQL<\/figure>\n\n\n\n
MySQL ALTER TABLE – Add columns to a table<\/h2>\n\n\n\n
The ALTER TABLE ADD<\/code> statement allows you to add one or more columns to a table.<\/p>\n\n\n\n
1) Add a column to a table<\/h3>\n\n\n\n
To add a column<\/a> to a table, you use the ALTER TABLE ADD<\/code> syntax:<\/p>\n\n\n
ALTER<\/span> TABLE<\/span> table_name\nADD<\/span> \n    new_column_name column_definition\n    [FIRST<\/span> | AFTER<\/span> column_name]\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax:<\/p>\n\n\n\n