Wiki

Pengantar Bahasa Query:UTS 2: Difference between revisions

← Older edit
Kangtain (talk | contribs)
Bureaucrats, Interface administrators, Suppressors, Administrators
9,154 edits
VisualWikitext
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
<syntaxhighlight lang="shell">
<syntaxhighlight lang="shell">
sudo mysql -u root
sudo mysql -u root
</syntaxhighlight>


</syntaxhighlight><syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
CREATE DATABASE mustain;
CREATE DATABASE mustain;
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
use mustain;
use mustain;
</syntaxhighlight>


</syntaxhighlight><syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
CREATE TABLE nilai ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real );
CREATE TABLE nilai ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real );
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85');
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85');
</syntaxhighlight>
</syntaxhighlight>
Line 18: Line 26:
<syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.028','PERTIWI SARI','KBP-04.1','70','85','90');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.028','PERTIWI SARI','KBP-04.1','70','85','90');
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.030','NGATINI','KBS-04.2','90','90','85');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.030','NGATINI','KBS-04.2','90','90','85');
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.037','NUR BADRIYAH','KBS-04.2','95','90','85');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.037','NUR BADRIYAH','KBS-04.2','95','90','85');
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.039','NUR CAHYO NINGSIH','KBP-04.1','75','75','85');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.039','NUR CAHYO NINGSIH','KBP-04.1','75','75','85');
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.043','FITRIANTI','KBS-04.1','65','50','59');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.043','FITRIANTI','KBS-04.1','65','50','59');
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.046','AGUSTINA VIRYANTI','KBS-04.2','80','80','70');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.046','AGUSTINA VIRYANTI','KBS-04.2','80','80','70');
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.056','NOVI ASMININGRUM','KBP-04.2','48','50','65');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.056','NOVI ASMININGRUM','KBP-04.2','48','50','65');
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.060','FRANGKY YOHANES TORAR','KBP-04.1','60','90','50');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.060','FRANGKY YOHANES TORAR','KBP-04.1','60','90','50');
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.909','EKA MADYAWATI','KBS-04.2','75','70','70');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.909','EKA MADYAWATI','KBS-04.2','75','70','70');
</syntaxhighlight><syntaxhighlight lang="sql">
</syntaxhighlight>
 
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50');
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50');
</syntaxhighlight>
</syntaxhighlight>
*Memperlihatkan data yang sudah di input
*Memperlihatkan data yang sudah di input
<syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
SELECT * FROM nilai
SELECT * FROM nilai
</syntaxhighlight>
</syntaxhighlight>
[[Category:Materi]]
[[Category:Matkul]]
[[Category:Pengantar Bahasa Query]]
Retrieved from "https://kangtain.com/wiki/index.php/Pengantar_Bahasa_Query:UTS_2"