Create

PRAGMA encoding = "UTF-8";
drop table if exists cities;
create TABLE cities (
id text NOT NULL PRIMARY KEY,
name text,
population int,
date_mod text);


Insert

/* cities */
insert into cities (id, Name, Population, date_mod)
 values ('t0711','郡山', 61475,'2001-9-21');
insert into cities (id, Name, Population, date_mod)
 values ('t0712','会津若松', 43829,'2001-4-27');
insert into cities (id, Name, Population, date_mod)
 values ('t0713','白河', 23165,'2001-5-18');
insert into cities (id, Name, Population, date_mod)
 values ('t0714','福島', 73856,'2001-6-23');
insert into cities (id, Name, Population, date_mod)
 values ('t0715','喜多方', 63814,'2001-7-21');
insert into cities (id, Name, Population, date_mod)
 values ('t0716','二本松', 53897,'2001-8-29');
insert into cities (id, Name, Population, date_mod)
 values ('t0717','いわき', 42381,'2001-7-18');
insert into cities (id, Name, Population, date_mod)
 values ('t0718','相馬', 43729,'2001-10-9');
insert into cities (id, Name, Population, date_mod)
 values ('t0719','須賀川', 81625,'2001-8-14');

Read

.header off
.mode column
select id,name,population,date_mod from cities;