最近想整合DZ与DEDECMS,无赖不管怎么弄都整合不了,于是想了一个比较土的办法,每次手动导入会员的信息。于是写了一SQL语句.......
insert into cdb_uc_members(uid,username,password,email) select mid,userid,pwd,email from dede_member where mid not in(select uid as mid from cdb_uc_members)
insert into cdb_uc_members(uid,username,password,email,salt) select mid,userid,md5(concat(pwd,'123456')),,email,'123456'
from dede_member where mid not in(select uid as mid from cdb_uc_members)
运行后提示如下错误:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cdb_uc_members(uid,username,password,email,salt) select mid,userid,md5(concat(pw' at line 1