为什么用create ...select 报错，说这张表不存在
CREATE TABLE employee_goods_brand(
brand_id SMALLINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
brand_name VARCHAR(40) NOT NULL
)
SELECT brand_name FROM goods_brand GROUP BY goods_brand;
[Err] 1146 - Table 'sqltest.goods_brand' doesn't exist
