Skip to content

Instantly share code, notes, and snippets.

@kathangeorg

kathangeorg/gist:3295201

Created August 8, 2012 13:56
Show Gist options
  • Save kathangeorg/3295201 to your computer and use it in GitHub Desktop.
Save kathangeorg/3295201 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL ALTER a bunch of TABLES
Raw
gistfile1.txt
select concat("alter table ",TABLE_SCHEMA,".",TABLE_NAME," CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;")
from information_schema.TABLES where TABLE_SCHEMA="SWZM2";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment