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