Wiki

Pengantar Bahasa Query:UTS 2: Difference between revisions

Kangtain (talk | contribs)
Bureaucrats, Interface administrators, Suppressors, Administrators
9,154 edits
VisualWikitext
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..."
 
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
  sudo mysql -u root
   
<syntaxhighlight lang="shell">
sudo mysql -u root
</syntaxhighlight>


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


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


CREATE TABLE npm1121040022 ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real );
<syntaxhighlight lang="sql">
CREATE TABLE nilai ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real );
</syntaxhighlight>


INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85');
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85');
</syntaxhighlight>


INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85');
<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');
</syntaxhighlight>
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.028','PERTIWI SARI','KBP-04.1','70','85','90');
</syntaxhighlight>


INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.028','PERTIWI SARI','KBP-04.1','70','85','90');
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.030','NGATINI','KBS-04.2','90','90','85');
</syntaxhighlight>


INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.030','NGATINI','KBS-04.2','90','90','85');
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.037','NUR BADRIYAH','KBS-04.2','95','90','85');
</syntaxhighlight>


INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.037','NUR BADRIYAH','KBS-04.2','95','90','85');
<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');
</syntaxhighlight>


INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.039','NUR CAHYO NINGSIH','KBP-04.1','75','75','85');
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.043','FITRIANTI','KBS-04.1','65','50','59');
</syntaxhighlight>


INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.043','FITRIANTI','KBS-04.1','65','50','59');
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.046','AGUSTINA VIRYANTI','KBS-04.2','80','80','70');
</syntaxhighlight>


INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.046','AGUSTINA VIRYANTI','KBS-04.2','80','80','70');
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.056','NOVI ASMININGRUM','KBP-04.2','48','50','65');
</syntaxhighlight>


INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.056','NOVI ASMININGRUM','KBP-04.2','48','50','65');
<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');
</syntaxhighlight>


INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.060','FRANGKY YOHANES TORAR','KBP-04.1','60','90','50');
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.909','EKA MADYAWATI','KBS-04.2','75','70','70');
</syntaxhighlight>


INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.909','EKA MADYAWATI','KBS-04.2','75','70','70');
<syntaxhighlight lang="sql">
INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50');
</syntaxhighlight>


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
<syntaxhighlight lang="sql">
SELECT * FROM nilai
</syntaxhighlight>
 
[[Category:Materi]]
[[Category:Matkul]]
[[Category:Pengantar Bahasa Query]]
Retrieved from "https://kangtain.com/wiki/index.php/Pengantar_Bahasa_Query:UTS_2"