Sql: How to add multiple entries in sql tables [duplicate]

Question

Kindly advice how to execute multiple commands in 1 go for adding entries in sql table.

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

Expected

+---------------------+---------------+------+-----+---------+-------+
| 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.

Thanks,

I have a suspicion, that something is wrong with your DB structure. Why do you need so many similar columns? — user4035
– user4035, Commented Sep 20, 2014 at 7:38

timo.rieber · Accepted Answer · 2014-09-20 07:44:47Z

0

Referring to the mysql documentation you can add multiple columns with one alter table command.

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

For example:

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

answered Sep 20, 2014 at 7:44

timo.rieber

3,8773 gold badges34 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sql: How to add multiple entries in sql tables [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related