Skip to content

Instantly share code, notes, and snippets.

@fuchao2012

fuchao2012/alter table

Created July 1, 2015 04:49
Show Gist options
  • Save fuchao2012/4a3f9b0c32d8e1eebf79 to your computer and use it in GitHub Desktop.
Save fuchao2012/4a3f9b0c32d8e1eebf79 to your computer and use it in GitHub Desktop.
Download ZIP
alter table column type
Raw
alter table
ALTER TABLE apipic CHANGE text text VARCHAR(1024);
# desc:
# alter table <table name> change <column name> <column name> <new type>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment