A表
uid username password email groupid ...
1 admin admin888 [email protected] 1 ...
2 admin2 admin888 [email protected] 5 ...
5 admin3 admin888 [email protected] 7 ...
B表
id uname pw mail gid
我要将A表的内容按照UID的排序写入到B表
也就是说要达到
B表
id uname pw mail gid
1 admin admin888 [email protected] 2
2 admin2 admin888 [email protected] 2
5 admin3 admin888 [email protected] 2 让B表的ID跟随A表的UID 而不是顺序写入!
似乎用表读取表...具体不清楚
uid username password email groupid ...
1 admin admin888 [email protected] 1 ...
2 admin2 admin888 [email protected] 5 ...
5 admin3 admin888 [email protected] 7 ...
B表
id uname pw mail gid
我要将A表的内容按照UID的排序写入到B表
也就是说要达到
B表
id uname pw mail gid
1 admin admin888 [email protected] 2
2 admin2 admin888 [email protected] 2
5 admin3 admin888 [email protected] 2 让B表的ID跟随A表的UID 而不是顺序写入!
似乎用表读取表...具体不清楚
A表是 A_user
B表是 B_user
insert into B_user select uid as id,username as uname,password as pw,email as mail,groupid as gid from a_user order by uid asc;