智慧职教: 执行完下面的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);
1