Skip to content

Instantly share code, notes, and snippets.

@jstenquist
Created December 14, 2012 18:34
Show Gist options
  • Save jstenquist/4287537 to your computer and use it in GitHub Desktop.
Save jstenquist/4287537 to your computer and use it in GitHub Desktop.
Standard MySQL Alter table process
// connect to database
mysql -h 192.168.1.1 -u myuser -p'mypass' db_phonebook
// alter the table
ALTER TABLE contacts MODIFY first_name varchar2(100) not null;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment