首頁猿問請問如下這一串代碼為什么在PHPM...

請問如下這一串代碼為什么在PHPMYADMIN執(zhí)行錯誤？該怎么修改？

MySQL

幕布斯7119047 2022-05-01 14:10:50

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 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,ADD `check_user` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULLALTER TABLE `ecs_goods` ADD `is_display` TINYINT( 1 ) NOT NULL DEFAULT '0'ALTER TABLE `ecs_goods` ADD `seller_id` INT NOT NULLALTER TABLE `ecs_goods` ADD `seller_cat_id` SMALLINT NOT NULL DEFAULT '0' COMMENT '商品對應(yīng)的入駐商家分類' AFTER `cat_id`ALTER TABLE `ecs_goods_cat` ADD `seller_cat_id` SMALLINT NOT NULL COMMENT '商品對應(yīng)的入駐商家分類' 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'ALTER TABLE `ecs_cart` ADD `seller_id` INT NOT NULL DEFAULT '0'這一串為嘛在PHPMYADMIN執(zhí)行錯誤#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

查看完整描述

2 回答

紅顏莎娜

TA貢獻(xiàn)1842條經(jīng)驗獲得超13個贊

親，你在create database d1；這個語句后面需要加“;”表示結(jié)束，創(chuàng)建d1數(shù)據(jù)庫。
創(chuàng)建完數(shù)據(jù)庫后，需要use d1;這個語句，表示進(jìn)入你新建的一個數(shù)據(jù)庫，進(jìn)去建表。

反對回復(fù) 2022-05-04

慕森王

TA貢獻(xiàn)1777條經(jīng)驗獲得超3個贊

批量執(zhí)行mysql語句時，每句語句結(jié)束要加上“;”，表示執(zhí)行當(dāng)前語句，所以要改下語句。

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 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , ADD `check_user` VARCHAR( 100 ) CHARACTER SET 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` INT NOT NULL; ALTER TABLE `ecs_goods` ADD `seller_cat_id` SMALLINT NOT NULL DEFAULT '0' COMMENT '商品對應(yīng)的入駐商家分類' AFTER `cat_id`; ALTER TABLE `ecs_goods_cat` ADD `seller_cat_id` SMALLINT NOT NULL COMMENT '商品對應(yīng)的入駐商家分類' 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'; ALTER TABLE `ecs_cart` ADD `seller_id` INT NOT NULL DEFAULT '0';