1. database level commands:

> create database blue ;
> show databases ;
> drop database blue ;
> show databases ;
> create database blue ;
> use blue ;



2. creating/dropping/altering columns a table:

> create table Address ( First_Name varchar(30) not null, Last_Name varchar(30) not null, Age int, Sex enum( 'M', 'F' ) default 'F' ) ;

> show tables ;
> show tables from blue ;

> show columns from Address ;                                                        describes the columns
> describe Address ;

> alter table Address change First_Name FirstName varchar(35) ;                      alter column
> alter table Address change FirstName First_Name varchar(35) not null ;
> alter table Address change Last_Name Last_Name varchar(35) not null ;
> alter table Address add Id int primary key auto_increment ;                        add a column
> alter table Address add Gogo int(20) not null ;
> alter table Address drop Gogo ;                                                    delete a column

> alter table Address rename Addresses ;                                             rename a table
> alter table Addresses rename Address ;

> create table gogo select * from Address ;                                          duplicate a table

> drop table gogo ;                                                                  drop a table



3. inserting/updating/deleting rows in a table

> insert into Address ( First_Name, Last_Name, Age ) values ( "Sabrina", "Noname", "10" ) ;     inserting rows of data
> insert into Address ( Last_Name, First_Name, Sex ) values ( "Bimbam", "Sam", "M" ) ;
> select * from Address ;                                                                     shows all the contents

> insert into Address ( First_Name ) values ( "Joe" ) ;
> update Address set Sex="M" where First_Name="Joe" ;                                         change values in an existing row
> select * from Address where First_Name="Joe" ;                                              show just one row

> insert into Address ( First_Name, Last_Name ) values ( "Julie", "Balu" ) ;
> insert into Address ( First_Name, Last_Name, Sex ) values ( "Julie", "Balu", "M" ) ;
> select * from Address ;
> select * from Address where First_Name="Julie" and Sex="M" ;                                focus on the one row
> delete from Address  where First_Name="Julie" and Sex="M" ;                                 deleting one row
> select * from Address ;



4. searching in a table:

> select First_Name from Address ;                                     selects the column
> select First_Name from Address where Sex="M" ;                       select column based on criterion from other column
> select First_name Last_Name from Address where Sex="F" ;

> select * from Address ;                                              the full table
> select * from Address where Id=3 ;                                   the full row for given column value
> select * from Address order by First_Name ;                          sorting
> select * from Address order by Sex, Last_Name ;