Create

use city;
SET NAMES utf8;
drop table if exists cities;
create table cities (id varchar(10) primary key, name text, population int, date_mod date);
quit


Insert

use city;
SET NAMES utf8;
insert into cities set id='t3321',name='岡山',population=81634,date_mod='2001-7-12';
insert into cities set id='t3322',name='倉敷',population=41927,date_mod='2001-4-1';
insert into cities set id='t3323',name='津山',population=34178,date_mod='2001-6-29';
insert into cities set id='t3324',name='玉野',population=67215,date_mod='2001-9-18';
insert into cities set id='t3325',name='笠岡',population=74936,date_mod='2001-1-17';
insert into cities set id='t3326',name='井原',population=84127,date_mod='2001-7-21';
insert into cities set id='t3327',name='総社',population=95234,date_mod='2001-8-22';
insert into cities set id='t3328',name='高梁',population=46178,date_mod='2001-9-23';
insert into cities set id='t3329',name='新見',population=51823,date_mod='2001-10-2';
quit

Read

use city;
SET NAMES utf8;
select * from cities;
quit