How to bulk rename table MySQL
Kedar
Are you tired of manually renaming MySQL tables, one by one, especially when dealing with a large number of them? In this guide, we’ll introduce you to a MySQL stored…
Browsing Tag
Rename table MySQL
1 post
Browsing Tag
6 responses to “How to bulk rename table MySQL”
Can you give me script of this procedure I want to run this procedure in script giving a sourceprefix and destination prefix
It’s there in the article… http://kedar.nitty-witty.com/wp-content/uploads/2010/02/prefix_all.sql_.txt
I need a store procedure where if in one table an entry is abc123 | xyz123 and other table entry is lmn456 | rst456 then i want a third table which should map abc123 | lmn456 and xyz | rst456. I want a sql script as it runs faster than a program from java or etc. Can you help.
Stupid wordpress is breaking all the single and double quotes by changing them to the typographically-fancy versions. OP, you might put that stored procedure into a -pre- or -code- wrapper.
Arthur,
Thanks for suggestion; I will make that change.
Mean while you can also download the code from: “Download the Procedure: prefix_all”
Thanks,
Kedar.
really good example