mysql - day1

day1.sql

/*
day 1  
mysql
*/
select database();
show databases;
create database world;
show databases;
use world;
select database();
create database if not exists mydb;
show databases;
use mydb;
select database();
create database mydb1 character set latin1 collate latin1_swedish_ci;
show databases;
use mydb1;
select database();
show create database mydb1;
show create database world\g;
alter database world character set latin1 collate latin1_swedish_ci;
use world;
show create database world;
show databases;
drop database mydb;
show databases;
select database();
drop database mydb1;
show databases;
drop database world;
select database();
show databases;
drop database if exists world;/*it will generate warning*/
/*-----------------------------------------*/

create table city
(
id int(11) auto_increment,
name char(35) default '' not null,
countrycode char(3) not null,
district char(20) not null,
population int(11) default 0,
primary key(id)
)
engine=myisam charset=latin1 comment='table city';

/*------------------------------------------*/