How do you create a TABLE in MySQL?

To create a table in MySQL you will need to use the CREATE TABLE function. This is simple enough to use, a simple example of creating a users table is below, it has a unique id (Primary Key) with a unique username and a password field (which I would recommend storing as an MD5).

CREATE TABLE users (id INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,

username VARCHAR( 16 ) NOT NULL ,

password CHAR( 32 ) NOT NULL ,

UNIQUE (

username

)

);