Question

求解一段mysql代码，提示错误。。。

ALTER TABLE `ecs_goods` ADD `love` INT( 10 ) NOTNULLDEFAULT '0';
错误提示：

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOTNULLDEFAULT '0'' at line 1
哪里错了呢？？？

Answer 1

ALTER TABLE `ecs_goods` ADD `love` INT( 10 ) NOT NULL DEFAULT '0';