摘要: insert into tp_members(uid,uname,realname,password,identity,email,rtime,ltime,lip)( select uid as uid,username as uname,realname,password,id as identity,email,regdate as rtime,lasttime as ltime,lastip as lip from common_member) 1.INSERT INTO SELECT语句 语句形式为:Insert into Table2(field1,field2,...)... 阅读全文
posted @ 2012-02-28 17:22 haiwei.sun 阅读(381) 评论(0) 推荐(0) 编辑
返回顶部