MySQL Adding a database and table

Log in with a user which has the correct privileges

mysql> CREATE DATABASE port22;
Query OK, 1 row affected (0.00 sec)

Change to the new database.

mysql> use port22;
Database changed

Create a new table with an auto increment ID, password and email fields.

mysql> CREATE TABLE user (
    -> id TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
    -> pass VARCHAR(64),
    -> email VARCHAR(255)
    -> );
Query OK, 0 rows affected (0.00 sec)

18 Feb 2012 | Tags ( MySQL )