1 2 3 |
create table goods_brands ( id int unsigned primary key auto_increment, name varchar(40) not null) select brand_name as name from goods group by brand_name; |
神奇
未经允许不得转载:MR LYU » 创建表并添加数据一句sql搞定
1 2 3 |
create table goods_brands ( id int unsigned primary key auto_increment, name varchar(40) not null) select brand_name as name from goods group by brand_name; |
神奇
未经允许不得转载:MR LYU » 创建表并添加数据一句sql搞定