テストテーブル [SQL]

sqlite テスト用

create table emp (emp_id NUMBER NOT NULL, name TEXT,department_id NUMBER,sarary NUMBER);
insert into emp values (001,'caesar',100,1000);
insert into emp values (002,'scipio',100,2000);
insert into emp values (003,'augustus',100,3000);
insert into emp values (004,'testtest',90,20);
insert into emp values (005,'aaaaaa',90,1000);


create table department (department_id NUMBER NOT NULL,dept_name TEXT);

insert into department values (100,'senatus');
insert into department values (90,'princepus');
insert into department values (600,'german');


結合してみる。
SELECT d.department_id,dept_name, name, sarary FROM department d LEFT OU
TER JOIN emp e ON d.department_id = e.department_id;

JUGEMテーマ：コンピュータ

.dumpすればSQLをはける。

sqlite>.dump
BEGIN TRANSACTION;
DELETE FROM sqlite_sequence;
CREATE TABLE emp (emp_id NUMBER NOT NULL, name TEXT,department_id NUMBER,sarary
NUMBER);
INSERT INTO "emp" VALUES(1,'caesar',100,1000);
INSERT INTO "emp" VALUES(2,'scipio',100,2000);
INSERT INTO "emp" VALUES(3,'augustus',100,3000);
INSERT INTO "emp" VALUES(4,'testtest',90,20);
INSERT INTO "emp" VALUES(5,'aaaaaa',90,1000);
CREATE TABLE department (department_id NUMBER NOT NULL,dept_name TEXT);
INSERT INTO "department" VALUES(100,'senatus');
INSERT INTO "department" VALUES(90,'princepus');
INSERT INTO "department" VALUES(600,'german');
COMMIT;