MySQL

From wiki.mikejung.biz
Revision as of 19:21, 29 March 2012 by Admin (talk | contribs) (Created page with "==MySQL== Some learn as I go commands ===Create a Database/Table=== <pre> CREATE database; </pre> <pre> CREATE TABLE testtable ( id INT UNSIGNED NOT FULL, col1 CHAR(5) CHARAC...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

MySQL

Some learn as I go commands

Create a Database/Table

CREATE database;
CREATE TABLE testtable
(
id INT UNSIGNED NOT FULL,
col1 CHAR(5) CHARACTER SET utf8,
col2 DATE DEFAULT '2012-03-29'
);