User:John/CASQL

From Orain Meta
Jump to navigation Jump to search

Whether you like this process or not, idk. It works, I use it. Got it?

SELECT * from globaluser WHERE gu_home_db = "olddb";

UPDATE globaluser SET  gu_home_db = "newdb" WHERE gu_home_db = "olddb";

SELECT * from localnames WHERE ln_wiki = "olddb";

UPDATE localnames SET ln_wiki = "newdb" WHERE ln_wiki = "olddb";

SELECT * from localuser WHERE lu_wiki = "olddb";

UPDATE localuser SET lu_wiki = "newdb" WHERE lu_wiki = "olddb";