智慧职教: 执行完下面的SQL语句,goods表中有几条记录?DROP TABLE IF EXISTS sCarInfo;CREATE TABLE sCarInfo(gdID INT ,uID INT,scNum INT,PRIMARY KEY(gdID,uID)) CHARSET utf8;INSERT INTO sCarInfo VALUES(1,1,2);INSERT INTO sCarInfo VALUES(1,1,3);INSERT INTO sCarInfo VALUES(2,1,2);INSERT INTO sCarInfo VALUES(1,2,2);INSERT INTO sCarInfo VALUES(1,null,2);INSERT INTO sCarInfo VALUES(null,1,2);
智慧职教: 执行完下面的SQL语句,goods表中有几条记录?DROP TABLE IF EXISTS sCarInfo;CREATE TABLE sCarInfo(gdID INT ,uID INT,scNum INT,PRIMARY KEY(gdID,uID)) CHARSET utf8;INSERT INTO sCarInfo VALUES(1,1,2);INSERT INTO sCarInfo VALUES(1,1,3);INSERT INTO sCarInfo VALUES(2,1,2);INSERT INTO sCarInfo VALUES(1,2,2);INSERT INTO sCarInfo VALUES(1,null,2);INSERT INTO sCarInfo VALUES(null,1,2);
智慧职教: 购物车表sCarInfo定义如下,下面说法错误的是:DROP TABLE IF EXISTS sCarInfo;CREATE TABLE sCarInfo(gdID INT ,--商品IDuID INT,--用户IDscNum INT,--购买数量scTime DATETIME--购买时间) CHARSET utf8;
智慧职教: 购物车表sCarInfo定义如下,下面说法错误的是:DROP TABLE IF EXISTS sCarInfo;CREATE TABLE sCarInfo(gdID INT ,--商品IDuID INT,--用户IDscNum INT,--购买数量scTime DATETIME--购买时间) CHARSET utf8;
1