#1064 - You have an error in your SQL syntax; check the manual that corresponds
错误信息 #1064 - 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
'ALTER TABLE `ecs_goods` ADD `check_status` TINYINT NOT NULL DEFAULT '0', ADD
`c' at line 3
完整代码
ALTER TABLE `ecs_admin_user` ADD`seller_id` INT NOT NULL DEFAULT '0' COMMENT '入驻商家ID'
ALTER TABLE `ecs_goods` ADD `check_status`TINYINT NOT NULL DEFAULT '0',
ADD `check_cause` VARCHAR( 255 ) CHARACTERSET utf8 COLLATE utf8_general_ci NOT NULL ,
ADD `check_user` VARCHAR( 100 ) CHARACTERSET utf8 COLLATE utf8_general_ci NOT NULL
ALTER TABLE `ecs_goods` ADD `is_display`TINYINT( 1 ) NOT NULL DEFAULT '0'
ALTER TABLE `ecs_goods` ADD `seller_id` INTNOT NULL
ALTER TABLE `ecs_goods` ADD `seller_cat_id`SMALLINT NOT NULL DEFAULT '0' COMMENT '商品对应的入驻商家分类' AFTER `cat_id`
ALTER TABLE `ecs_goods_cat` ADD`seller_cat_id` SMALLINT NOT NULL COMMENT '商品对应的入驻商家分类' AFTER `cat_id`
ALTER TABLE `ecs_order_info` ADD`seller_id` INT NOT NULL DEFAULT '0' COMMENT '入驻商家ID'
ALTER TABLE `ecs_delivery_order` ADD`seller_id` INT NOT NULL DEFAULT '0'
ALTER TABLE `ecs_back_order` ADD`seller_id` INT NOT NULL DEFAULT '0'
ALTER TABLE `ecs_comment` ADD `seller_id`INT NOT NULL DEFAULT '0'
ALTER TABLE `ecs_booking_goods` ADD`seller_id` INT NOT NULL DEFAULT '0'
ALTERTABLE `ecs_cart` ADD `seller_id` INT NOT NULL DEFAULT '0'
最新回答
奇葩奇葩蹦擦擦
2025-06-26 21:21:59
通过alter table 加列的，只要一个add就可以，后面跟着列信息。
alter table tablename add columnname datatype,columnname datatype;
追问
要怎么加，我对数据库不懂，找到错误了，只要在每名后加分号就完美解决
热门标签
