phpMyAdmin Mass Collation Possible?
-
- Posts: 86
- Joined: Sun Mar 12, 2006 7:13 am
- Contact:
phpMyAdmin Mass Collation Possible?
I want to change all the tables in my database to a certain collation. However, I have 148 tables in the database. Is it possible to change the collation of the tables all at once or a quicker way?
method number one: write a script that could do this automaticaly
method number two: explanation is here http://lists.mysql.com/mysql/186286
method number two: explanation is here http://lists.mysql.com/mysql/186286