Sunday, February 17, 2008

Script ที่ใช้เวลาเปลี่ยน Database

SQLSyncDB.txt

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)


at

2 comments:

  1. sangza3/02/2008 6:54 PM

    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);

    ReplyDelete
  2. Anonymous11/10/2008 10:59 PM

    Great work.

    ReplyDelete