Create

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


Insert

use city;
insert into cities set id='t3321',name='岡山',population=691734,date_mod='2001-2-15';
insert into cities set id='t3322',name='倉敷',population=923657,date_mod='2001-8-1';
insert into cities set id='t3323',name='津山',population=279358,date_mod='2001-7-29';
insert into cities set id='t3324',name='玉野',population=284615,date_mod='2001-5-18';
insert into cities set id='t3325',name='笠岡',population=741256,date_mod='2001-1-17';
insert into cities set id='t3326',name='井原',population=497521,date_mod='2001-4-21';
insert into cities set id='t3327',name='総社',population=217348,date_mod='2001-7-15';
insert into cities set id='t3328',name='高梁',population=152978,date_mod='2001-9-11';
insert into cities set id='t3329',name='新見',population=823495,date_mod='2001-10-2';
quit

Read

use city;
select * from cities;
quit