Brian: Created page with "==How to create a table in a MySQL database== Now that you have created your database, you will need to add some tables. Lets first log into mysql via the command line mys..."

2014-03-12T20:30:31Z

Created page with "==How to create a table in a MySQL database== Now that you have created your database, you will need to add some tables. Lets first log into mysql via the command line mys..."

New page

==How to create a table in a MySQL database==

Now that you have created your database, you will need to add some tables.

Lets first log into mysql via the command line

mysql -u <username> -p
use <databasename>

Now lets create the table, this is a simple table we use to track traffic on a site.

CREATE TABLE visitors (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
browser VARCHAR(50),
page VARCHAR(30),
confirmed CHAR(1),
signup_date DATE);

<sub>'''NOTE: MySQL does not terminate a command until you give a semicolon (;) at the end of SQL command.'''</sub>

Now lets check and confirm the table was inserted.

SHOW TABLES;

If you want to see the structure of the table

DESCRIBE visitors;

How to Create a Table in MySQL Database - Revision history

Brian: Created page with "==How to create a table in a MySQL database== Now that you have created your database, you will need to add some tables. Lets first log into mysql via the command line mys..."