CREATE TABLE EMPLOYEE (
Emp_NO INTEGER PRIMARY KEY,
Emp_Name TEXT NOT NULL,
Emp_Add TEXT NOT NULL,
Emp_Phone TEXT NOT NULL,
Dept_No TEXT NOT NULL,
Dept_Name TEXT NOT NULL,
Salary TEXT NOT NULL
);
INSERT INTO EMPLOYEE (Emp_NO, Emp_Name, Emp_Add, Emp_Phone, Dept_No, Dept_Name, Salary) VALUES
(1, 'Ahmad Fauzi', 'Jl. Merdeka No. 10, Jakarta', '081234567890', 'D01', 'IT', '7500000'),
(2, 'Siti Rahma', 'Jl. Sudirman No. 45, Bandung', '082345678901', 'D02', 'HRD', '6500000'),
(3, 'Budi Santoso', 'Jl. Diponegoro No. 12, Surabaya', '083456789012', 'D03', 'Finance', '8000000'),
(4, 'Dewi Lestari', 'Jl. Gatot Subroto No. 88, Medan', '084567890123', 'D01', 'IT', '7000000'),
(5, 'Eko Prasetyo', 'Jl. Ahmad Yani No. 5, Semarang', '085678901234', 'D04', 'Marketing', '6000000'),
(6, 'Fitriani', 'Jl. Asia Afrika No. 20, Bandung', '086789012345', 'D02', 'HRD', '6200000'),
(7, 'Guntur Wicaksono', 'Jl. Pemuda No. 15, Surabaya', '087890123456', 'D03', 'Finance', '8500000');
select * from
0 Response to "Create table, insert table, select table postrgres"
Posting Komentar