rizaarifudin[dot]com

Berbagi ilmu, pengalaman, tips dan trik, software

You are here: » SQL Untuk Isi Tabel

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

Posted by 2 Responses
 

Free Email Newsletter

Stay Updates with this Blog. Get Free email newsletter updates..

And then confirm your email subcription

   

2 Comments to “SQL Untuk Isi Tabel”

  1. Thank you for your information! Honestly I have never seen anything that cool.

Leave your comment here:

*

Apr
5
2011
 
Archives
Chat
Name:
Email:
For:  
Mail will not be published
(but it's required)