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