Is there a single or a one line command to modify all tables within a database. I would like to issue this command in every table within a database:
ALTER TABLE `table_name` CONVERT TO CHARACTER SET utf8;
My objective is to modify the charset from latin1 to utf8 to all tables.
UPDATE: RDBMS is MySQL