Create

connect to cities user scott using tiger;
drop table cities;
create table cities (id varchar(10) not null primary key, name varchar(32), population int, date_mod date);


Insert

connect to cities user scott using tiger;
insert into cities (id,name,population,date_mod) values ('t2871','神戸',37987,'2001-5-14');
insert into cities (id,name,population,date_mod) values ('t2872','姫路',59132,'2001-7-23');
insert into cities (id,name,population,date_mod) values ('t2873','尼崎',46238,'2001-1-3');
insert into cities (id,name,population,date_mod) values ('t2874','西宮',93729,'2001-8-19');
insert into cities (id,name,population,date_mod) values ('t2875','洲本',85127,'2001-11-21');
insert into cities (id,name,population,date_mod) values ('t2876','明石',53173,'2001-3-12');
insert into cities (id,name,population,date_mod) values ('t2877','芦屋',79184,'2001-12-8');
insert into cities (id,name,population,date_mod) values ('t2878','伊丹',56812,'2001-6-15');
insert into cities (id,name,population,date_mod) values ('t2879','豊岡',76514,'2001-10-14');
insert into cities (id,name,population,date_mod) values ('t2880','宝塚',36916,'2001-12-12');

Read

connect to cities user scott using tiger;
select * from cities;