Wiki

Pengantar Bahasa Query:Tugas 1: Difference between revisions

← Older edit
Kangtain (talk | contribs)
Bureaucrats, Interface administrators, Suppressors, Administrators
9,154 edits
VisualWikitext
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
<syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
CREATE DATABASE mustain_db;
CREATE DATABASE mustain_db;
</syntaxhighlight>


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


</syntaxhighlight><syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
CREATE TABLE nama(
CREATE TABLE nama(
   -> npm char(15),
   -> npm char(15),
Line 14: Line 16:
   -> umur real
   -> umur real
   -> );
   -> );
</syntaxhighlight>


</syntaxhighlight><syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
SHOW TABLES;
SHOW TABLES;
</syntaxhighlight>


</syntaxhighlight><syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
INSERT INTO nama (npm, nama, kota_asal, tgl_lahir, jenjang, umur)
INSERT INTO nama (npm, nama, kota_asal, tgl_lahir, jenjang, umur)
     -> values
     -> values
     -> ('625374987','Mustain','Semarang','2000-09-20','S1','22');
     -> ('625374987','Mustain','Semarang','2000-09-20','S1','22');
</syntaxhighlight>Atau<syntaxhighlight lang="sql">
</syntaxhighlight>
 
Atau
 
<syntaxhighlight lang="sql">
INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur) -> values -> ('625374987','Dika','Semarang','2000-09-20','S1','22');
INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur) -> values -> ('625374987','Dika','Semarang','2000-09-20','S1','22');
</syntaxhighlight>Memperlihatkan Field yang sudah di input<syntaxhighlight lang="sql">
</syntaxhighlight>
 
Memperlihatkan Field yang sudah di input
 
<syntaxhighlight lang="sql">
SELECT * FROM TKP_Pagi;
SELECT * FROM TKP_Pagi;
</syntaxhighlight>
</syntaxhighlight>
[[Category:Matkul]]
[[Category:Materi]]
[[Category:Pengantar Bahasa Query]]
Retrieved from "https://kangtain.com/wiki/index.php/Pengantar_Bahasa_Query:Tugas_1"