麻烦看看为什么报错呢?
CREATE TABLE tdb_goods_brands(
brand_id INT PRIMARY KEY AUTO_INCREMENT UNSIGNED, brand_name VARCHAR(40) NOT NULL
)
SELECT brand_name FROM tdb_goods GROUP BY brand_name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNSIGNED, brand_name VARCHAR(40) NOT NULL ) SELECT brand_name FROM tdb_goods GRO' at line 1