一模一樣為什么暴這個錯
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
2 回答
舉報
0/150
提交
取消
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
舉報
2016-08-22
應該是brand_name,不是brands_name。
2016-08-18
數據表沒有插入值吧