# Creates a Simple User table # Uses an auto-incrementing primary key as userId CREATE TABLE user ( userId INT NOT NULL AUTO_INCREMENT PRIMARY KEY, username VARCHAR(100), password VARCHAR(100) ) ENGINE=InnoDB;
CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, .... );
CREATE TABLE fact ( id SERIAL PRIMARY KEY NOT NULL, type VARCHAR(255), text TEXT );
( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) );