SQL

SQLの動作確認

code:sql

create table meibo (

id integer primary key,

name char(30) not null,

office char(30) not null

);

insert into meibo values (1, "taro", "osaka");

insert into meibo values (2, "jiro", "tokyo");

insert into meibo values (3, "saburo", "osaka");

select * from meibo where office = "osaka";

1 taro osaka

3 saburo osaka