Skip to content

Instantly share code, notes, and snippets.

@sephraim

sephraim/add_column.sql

Last active November 11, 2016 22:43
Show Gist options
  • Save sephraim/0d1f1d19d581a2361a4af751b28c7608 to your computer and use it in GitHub Desktop.
Save sephraim/0d1f1d19d581a2361a4af751b28c7608 to your computer and use it in GitHub Desktop.
Download ZIP
Add column to MySQL database
Raw
add_column.sql
ALTER TABLE `__TABLE__`
ADD `__COL__`
VARCHAR(255) NULL
DEFAULT NULL
COMMENT '__COMMENT__'
AFTER `__ANOTHER_COL__` ;
Raw
~README.md

Instead of using the 'AFTER' option, you can also use the 'FIRST' option.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment