Skip to content

Instantly share code, notes, and snippets.

@marchampson

marchampson/useful mysql

Created February 8, 2013 12:31
Show Gist options
  • Save marchampson/4738737 to your computer and use it in GitHub Desktop.
Save marchampson/4738737 to your computer and use it in GitHub Desktop.
Download ZIP
Useful mysql
Raw
useful mysql
Character encoding of tbl (where tbl = tablname):
show create table tbl\G
Update character set:
alter table <tablename> modify <columname> <type> character set utf8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment