Class 7: CCIS2630 PHP: Creating Tables

create MYDATABASE;
connect MYDATABASE;
create table SOMETHING (colname, datatype,...);
create table test ( testcol varchar(30));
create table model_cars ( make varchar(20), model varchar(30), year int, color varchar(12));
names can be anything you like
create table blah2 ( my_dec float(12,4));
Indexes/keys--primary:
create table model_cars (make varchar(20), model varchar(30), year int, color varchar(12), carnum int primary key auto_increment);