Mysql同表记录复制.

INSERT INTO

        表名(字段一,字段二, 字段三) SELECT 字段一, 字段二,字段三 FROM 表名

WHERE
        条件

--------------------------------------------------------------------------

例:

 

			Field	Type	Null	Key	Default	Extra
			id	int(11) unsigned	NO	PRI	NULL	auto_increment
			name	varchar(50)	NO		NULL
			pass	varchar(50)	NO		NULL

 

INSERT INTO
         users(name,pass) SELECT users.name, users.pass
FROM 
         users
WHERE
         users.id =1

---------------------------------------------------------------------------