1、使用INSERT...SELECT
将查询结果写入到数据表
INSERT [INTO] tbl_name [(col_name,...)] SELECT ...
eg:INSERT tdb_goods_cates(cate_name) SELECT goods_cate FROM tdb_goods GROUP BY goods_cate ;
将查询结果写入到数据表
INSERT [INTO] tbl_name [(col_name,...)] SELECT ...
eg:INSERT tdb_goods_cates(cate_name) SELECT goods_cate FROM tdb_goods GROUP BY goods_cate ;