PHP笔记--几个常用的mysql语句

1、把table1的所有项插入到table2（前提是两张表的字段要一致）

INSERT INTO `table1`( `value1`, `value2`, `value3`) (SELECT  `value1`, `value2, `value3`FROM `table1`)

2、查询table1中value1字段中重复的值

Select * From table1 Where `value1` In (Select `value1` From table1 Group By `value1` Having Count(*)>1) ORDER BY `table1 `.`value1` ASC

3、在table1表中复制value1字段

INSERT INTO `table1`( `value1`)  SELECT  `value1` FROM `table1`