Fqr8kAkj

1/*
2day 1  
3mysql
4*/
5select database();
6show databases;
7create database world;
8show databases;
9use world;
10select database();
11create database if not exists mydb;
12show databases;
13use mydb;
14select database();
15create database mydb1 character set latin1 collate latin1_swedish_ci;
16show databases;
17use mydb1;
18select database();
19show create database mydb1;
20show create database world\g;
21alter database world character set latin1 collate latin1_swedish_ci;
22use world;
23show create database world;
24show databases;
25drop database mydb;
26show databases;
27select database();
28drop database mydb1;
29show databases;
30drop database world;
31select database();
32show databases;
33drop database if exists world;/*it will generate warning*/
34/*-----------------------------------------*/
35
36create table city
37(
38id int(11) auto_increment,
39name char(35) default '' not null,
40countrycode char(3) not null,
41district char(20) not null,
42population int(11) default 0,
43primary key(id)
44)
45engine=myisam charset=latin1 comment='table city';
46
47/*------------------------------------------*/