ALTER TABLE mysql error

Question

I have create .sql file have a code like this:

ALTER TABLE `tb_1` ADD `ex1` TINYINT( 1 ) NOT NULL DEFAULT '0'
ALTER TABLE `tb_2` ADD `ex2` tinyint(1) NOT NULL DEFAULT '1'
ALTER TABLE `tb_3` ADD `ex2` varchar(35) NOT NULL

and I always get error when I try to import it to db.

And only work if I import one line by line.

What is the problem please?

In the future if you get an error, please include it in your question. Simply saying that you get an error in not enough. — Abe Miessler, Apr 12 '13 at 21:44

score 1 · Accepted Answer · answered Apr 12 '13 at 21:42

1

If you have consecutive SQL statements, you should terminate them with a ;

ALTER TABLE `tb_1` ADD `ex1` TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `tb_2` ADD `ex2` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `tb_3` ADD `ex2` varchar(35) NOT NULL;

answered Apr 12 '13 at 21:42

Stephen Fischer

2,445
2
23
38

ALTER TABLE mysql error

1 Answers1