一模一样为什么暴这个错
CREATE TABLE tdb_goods_brands (id SMALLINT PRIMARY KEY AUTO_INCREMENT,brands_name VARCHAR(40) NOT NULL) SELECT brand_name FROM tdb_goods GROUP BY brand_name;
报错:Field 'brands_name' doesn't have a default value
CREATE TABLE tdb_goods_brands (id SMALLINT PRIMARY KEY AUTO_INCREMENT,brands_name VARCHAR(40) NOT NULL) SELECT brand_name FROM tdb_goods GROUP BY brand_name;
报错:Field 'brands_name' doesn't have a default value
2016-08-18
举报