Hey,
Trying to convert ~70 tables to the character set latin1 and wondered if there was a quick way of doing this. SQL query I've got is:
ALTER TABLE tablename CONVERT TO CHARACTER SET latin1;
Sure, it works, but by that I would have to do each table 1-by-1.
Is there a quick "select all" I can put in replace for the tablename? I guessed * would work but it doesn't
Cheers.
Trying to convert ~70 tables to the character set latin1 and wondered if there was a quick way of doing this. SQL query I've got is:
ALTER TABLE tablename CONVERT TO CHARACTER SET latin1;
Sure, it works, but by that I would have to do each table 1-by-1.
Is there a quick "select all" I can put in replace for the tablename? I guessed * would work but it doesn't
Cheers.