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
Free Email Newsletter
And then confirm your email subcription
2 Comments to “SQL Untuk Isi Tabel”
Thank you for your information! Honestly I have never seen anything that cool.
Thank you for visiting my blog. this post just to make the task easier for my students