mysql add column 列_MySQL在指定列之前或之后插入列 (Add a column to an existing M

最新推荐文章于 2024-07-03 03:08:05 发布

dalle_openai

最新推荐文章于 2024-07-03 03:08:05 发布

阅读量655

点赞数

文章标签： mysql add column 列

本文链接：https://blog.csdn.net/weixin_36142226/article/details/113156461

版权

To add a column called email to the contacts table created in Create a basic MySQL table with a datatype of VARCHAR(80), use the following SQL statement: ALTER TABLE contacts ADD email VARCHAR(60); This first statement will add the email c

To add a column called email to the contacts table created in

Create a basic MySQL table with a datatype of VARCHAR(80), use the following SQL statement:

ALTER TABLE contacts ADD email VARCHAR(60);

This first statement will add the email column to the end of the table. To insert the new column after a specific column, such as name, use this statement:

ALTER TABLE contacts ADD email VARCHAR(60) AFTER name;

If you want the new column to be first, use this statement:

ALTER TABLE contacts ADD email VARCHAR(60) FIRST;