Pengantar Bahasa Query:UTS 2: Difference between revisions
Created page with " sudo mysql -u root CREATE DATABASE mustain; use mustain; CREATE TABLE npm1121040022 ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real ); INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85'); INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85'); INSERT INTO..." |
No edit summary |
||
| Line 30: | Line 30: | ||
INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50'); | INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50'); | ||
*Memperlihatkan data yang sudah di input | |||
SELECT * FROM npm1121040022 | |||