if exists ( show columns from lomo_track where field = 'reg_flag') begin ALTER TABLE `lomo_track` ADD `reg_flag` INT( 2 ) NOT NULL DEFAULT '1' AFTER `user_id` end报语法错误啊!
if exists ( show columns from lomo_track where field = 'reg_flag') begin ALTER TABLE `lomo_track` ADD `reg_flag` INT( 2 ) NOT NULL DEFAULT '1' AFTER `user_id` end报语法错误啊!
mysql> create table test.tablea as select * from foo.tablea;
Query OK, 6 rows affected (0.11 sec)
Records: 6 Duplicates: 0 Warnings: 0
把test库中的tablea表弄到foo库当中。