Skip to content

Instantly share code, notes, and snippets.

@gmilby
Created July 10, 2013 15:13
Show Gist options
  • Save gmilby/5967144 to your computer and use it in GitHub Desktop.
Save gmilby/5967144 to your computer and use it in GitHub Desktop.
my first command line table... i've been doing this 10 years - never made a table on command line in mysql...
mysql> CREATE TABLE messages (id INT(11) NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NULL,
text VARCHAR(255),
created_at INT(11),
updated_at INT(11),
PRIMARY KEY (id)) ENGINE=INNODB;
Query OK, 0 rows affected (0.05 sec)
mysql>
///so glad it worked lol
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment