两表结构一样时
insert into b select * from a
两表的字段不相同
把UserTable中的数据插入到UserTableOne中
insert into UserTableOne(UserNameO,ZhangHaoO,PwdO) select UserName,ZhangHao,Pwd from UserTable where字段=值
delete from UserTable where字段=值
两表结构一样时
insert into b select * from a
两表的字段不相同
把UserTable中的数据插入到UserTableOne中
insert into UserTableOne(UserNameO,ZhangHaoO,PwdO) select UserName,ZhangHao,Pwd from UserTable where字段=值
delete from UserTable where字段=值