一些用过的SQL语句

选择某个字段具有重复值的东西，计数什么的

SELECT caiming,count(caiming) FROM content_new_copy_copy GROUP BY caiming HAVING (count(caiming)>1)

插入表

INSERT IGNORE INTO content_dish2 SELECT * FROM content_dish_copy

创建表

CREATE table dish_tiaoliao (SELECT * FROM dish_copy_copy WHERE tiaoliao IS NOT NULL ORDER BY caixi ASC)