SQL Untuk Isi Tabel

SQL Untuk Isi Tabel

SQL sintax pada osting ini merupakan lanjutan dari posting sebelumnya.

INSERT INTO TheEmployees VALUES(‘Phil’,’Randwick’);
INSERT INTO TheEmployees VALUES (‘Andrew’,’Botany Bay’);
INSERT INTO TheEmployees VALUES (‘Peter’,’Townsville’);
INSERT INTO TheEmployees VALUES (‘Mary’,’Sydney’);
INSERT INTO TheEmployees VALUES (‘Michael’,’Manly’);
INSERT INTO TheEmployees VALUES (‘Paul’,’Randwick’);

INSERT INTO TheSupervisors VALUES (10,’Phil’);
INSERT INTO TheSupervisors VALUES (1,’Andrew’);
INSERT INTO TheSupervisors VALUES (2,’Peter’);

INSERT INTO TheCages VALUES (11,10,’Deer’);
INSERT INTO TheCages VALUES (1,1,’Den’);
INSERT INTO TheCages VALUES (2,1,’Aquarium’);
INSERT INTO TheCages VALUES (3,2,’Small Birds’);
INSERT INTO TheCages VALUES (4,1,’Large Aquarium’);
INSERT INTO TheCages VALUES (12,10,’Deer’);

INSERT INTO TheGuards VALUES (11,’Michael’);
INSERT INTO TheGuards VALUES (12,’Mary’);
INSERT INTO TheGuards VALUES (12,’Paul’);
INSERT INTO TheGuards VALUES (11,’Mary’);
INSERT INTO TheGuards VALUES (11,’Paul’);
INSERT INTO TheGuards VALUES (1,’Michael’);
INSERT INTO TheGuards VALUES (3,’Michael’);
INSERT INTO TheGuards VALUES (12,’Michael’);

INSERT INTO TheAnimals VALUES (‘Charly’,’male’,’lion’,’Kenya’,1990,12);
INSERT INTO TheAnimals VALUES (‘Arthur’,’male’,’bear’,’France’,1980,1);
INSERT INTO TheAnimals VALUES (‘Chloe’,’female’,’magpie’,’France’,1991,3);
INSERT INTO TheAnimals VALUES (‘Milou’,’male’,’leopard’,’France’,1993,11);
INSERT INTO TheAnimals VALUES (‘Tintin’,’male’,’leopard’,’France’,1993,11);
INSERT INTO TheAnimals VALUES (‘Charlotte’,’female’,’lion’,’Kenya’,1992,12);

INSERT INTO TheDiseases VALUES (‘Charly’,’ragging toothache’);
INSERT INTO TheDiseases VALUES (‘Charly’,’flu’);
INSERT INTO TheDiseases VALUES (‘Milou’,’sore throat’);
INSERT INTO TheDiseases VALUES (‘Chloe’,’flu’);

File sintax SQL dalam bentuk txt bisa di download di SQL untuk isi tabel

Selamat mencoba

Leave your comment here:

Click here to cancel reply.

Name (required)

Mail (will not be published) (required)

Website (Optional)

Subscribe to comments feed

CAPTCHA Code *