Skip to content

Instantly share code, notes, and snippets.

@AhmedHelalAhmed
Last active December 12, 2017 20:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save AhmedHelalAhmed/dc8b06728cce449c8deeac9b6948c140 to your computer and use it in GitHub Desktop.
Save AhmedHelalAhmed/dc8b06728cce449c8deeac9b6948c140 to your computer and use it in GitHub Desktop.
mysql - day1
/*
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';
/*------------------------------------------*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment