mysql - Sql:如何在sql表中添加多个条目

Question

这个问题已经有答案了:

Adding multiple columns AFTER a specific column in MySQL (11 个回答)

已关闭 8 年前。

请建议如何一次性执行多个命令以在 sql 表中添加条目。

mysql> desc detailed;
+---------------------+---------------+------+-----+---------+-------+
| Field               | Type          | Null | Key | Default | Extra |
+---------------------+---------------+------+-----+---------+-------+
| Id                  | roll(5)       | YES  | 1   | NULL    |       |
| Name                | varchar(896)  | NO   | 2   |         |       |
+---------------------+---------------+------+-----+---------+-------+

预计

+---------------------+---------------+------+-----+---------+-------+
| Field               | Type          | Null | Key | Default | Extra |
+---------------------+---------------+------+-----+---------+-------+
| Id                  | roll(5)       | YES  | 1   | NULL    |       |
| Name                | varchar(896)  | NO   | 2   |         |       |
| Value1              | varchar(102)  | Yes  |     | NULL    |       |
| Value2              | varchar(102)  | Yes  |     | NULL    |       |
| Value3              | varchar(102)  | Yes  |     | NULL    |       |
| Value4              | varchar(102)  | Yes  |     | NULL    |       |
+---------------------+---------------+------+-----+---------+-------+


ALTER TABLE detailed ADD `Value1` varchar(102) DEFAULT NULL;
ALTER TABLE detailed ADD `Value2` varchar(102) DEFAULT NULL;
ALTER TABLE detailed ADD `Value3` varchar(102) DEFAULT NULL;
ALTER TABLE detailed ADD `Value4` varchar(102) DEFAULT NULL;
-- and it's till 50 Value so very time consuming. 

谢谢

Answer 1

引用 mysql 文档，您可以使用一个 alter table 命令添加多个列。

You can issue multiple ADD, ALTER, DROP, and CHANGE clauses in a single ALTER TABLE statement, separated by commas. This is a MySQL extension to standard SQL, which permits only one of each clause per ALTER TABLE statement.

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

例如:

ALTER TABLE
    detailed
ADD Value1 varchar(102) DEFAULT NULL,
ADD Value2 varchar(102) DEFAULT NULL,
ADD Value3 varchar(102) DEFAULT NULL;