CREATE SELECT 列名不一致
之前講的例子
REATE TABLE tdb_goods_brands(
?? ?brand_id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
??? brand_name VARCHAR(40) NOT NULL
??? ?)
??? SELECT brand_name FROM tdb_goods GROUP BY brand_name;
tdb_goods_brands與tdb_goods 中的列名相同，如果列名不同，但是填寫(xiě)的數(shù)據(jù)內(nèi)容相同，應(yīng)該如何寫(xiě)。
謝謝！
2019-02-23
CREATE TABLE tdb_goods_brands(
?? ?brand_id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
??? brand_name VARCHAR(40) NOT NULL
??? ?)
??? SELECT name AS brand_name FROM tdb_goods GROUP BY brand_name;
加個(gè)AS就可以了，AS后面要跟創(chuàng)建的新表中的列名