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
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
CREATE DATABASE mustain_db;
<syntaxhighlight lang="sql">
CREATE DATABASE mustain_db;
</syntaxhighlight>


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


CREATE TABLE nama(
<syntaxhighlight lang="sql">
    -> npm char(15),
CREATE TABLE nama(
    -> nama char(30),
  -> npm char(15),
    -> kota_asal char(20),
  -> nama char(30),
    -> tgl_lahir datetime,
  -> kota_asal char(20),
    -> jenjang char(2),
  -> tgl_lahir datetime,
    -> umur real
  -> jenjang char(2),
    -> );
  -> umur real
  -> );
</syntaxhighlight>


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


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