MysqlMysql

  Main Menu

Home: Development: Mysql: Create_table
Create Table Example:

This is the actual sql I used to create the one of the tables for the amazing random tao of programming page.

create table tao (
id int(3) unsigned auto_increment primary key,
verse varchar(3), #//1.2
tao text # the meat
);

 

Here is the other one:

create table tao_caption (
id int(2) unsigned auto_increment primary key,
book varchar(30), #book 1 - hardware and softwaer
verse varchar(3), #1.x
tao_caption varchar(200) #// thus spake the master programmer...
);

 

So what if the whole thing tao thing fits on one page! It's still essential to normalize the data! :)

If you want more detailed information on how CREATE works, go to http://www.mysql.com/doc/C/R/CREATE_TABLE.html.