1.完全复制n列到另一个表,两表之间没有关联变量,从t_user 复制 username和password到t_user1(1种)
INSERT INTO 新表(字段1,字段2,.......) SELECT 字段1,字段2,...... FROM 旧表
INSERT INTO t_user1 (t_user1.name,t_user1.pass) SELECT t_user.username ,t_user.password FROM t_user;
2.完全复制n列到另一个表,两表之间有关联变量,需要按关联变量复制对应值过去,从t_user 复制password到t_user1,要求要和username对应(4种方法)
UPDATE t_user1 INNER JOIN t_user SET name = (SELECT username FROM t_user WHERE `password` = t_user1.pass) WHERE t_user.`password` = t_user1.pass;
UPDATE t_user1 SET name = (SELECT username FROM t_user WHERE `password` = t_user1.pass);
UPDATE t_user1 INNER JOIN t_user SET t_user1.`name` = t_user.username WHERE t_user.`password` = t_user1.pass;
UPDATE t_user1 INNER JOIN t_user ON t_user.`password` = t_user1.pass SET t_user1.`name` = t_user.username ;