delete from openfire.jiveUser where username <> "admin"
truncate
openfire.jivePresence
truncate openfire.jiveRoster
insert into
openfire.jiveUser
(username,plainPassword,creationDate,modificationDate) (select
DISTINCTROW
MEMBER_ID,
MEMBER_ID,
'001202458195089','001202458195089' from enados.member)
Sunday, February 17, 2008
Script ที่ใช้เวลาเปลี่ยน Database
SQLSyncDB.txt
Subscribe to:
Post Comments (Atom)
2 comments:
delete from openfire106.jiveUser where username <> "admin";
truncate openfire106.jivePresence;
truncate openfire.jiveRoster;
insert into
openfire106.jiveUser
(username,plainPassword,creationDate,modificationDate) (select
DISTINCTROW
MEMBER_ID,
MEMBER_ID,
'001204512861921','001204512861921' from enados.member);
Great work.
Post a Comment