Jump to content

Pengantar Bahasa Query:Tugas 1: Difference between revisions

From Wiki
← Older edit
Kangtain (talk | contribs)
Bureaucrats, Interface administrators, Suppressors, Administrators
9,154 edits
VisualWikitext
No edit summary
 
(6 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>
INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur)
 
    -> values
Atau
    -> ('625374987','Dika','Semarang','2000-09-20','S1','22');
 
<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
Memperlihatkan Field yang sudah di input
SELECT * FROM TKP_Pagi;
 
<syntaxhighlight lang="sql">
SELECT * FROM TKP_Pagi;
</syntaxhighlight>
 
[[Category:Matkul]]
[[Category:Materi]]
[[Category:Pengantar Bahasa Query]]

Latest revision as of 23:14, 19 November 2022

CREATE DATABASE mustain_db;

use mustain_db;

CREATE TABLE nama(
   -> npm char(15),
   -> nama char(30),
   -> kota_asal char(20),
   -> tgl_lahir datetime,
   -> jenjang char(2),
   -> umur real
   -> );

SHOW TABLES;

INSERT INTO nama (npm, nama, kota_asal, tgl_lahir, jenjang, umur)
    -> values
    -> ('625374987','Mustain','Semarang','2000-09-20','S1','22');

Atau 

INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur) -> values -> ('625374987','Dika','Semarang','2000-09-20','S1','22');

Memperlihatkan Field yang sudah di input 

SELECT * FROM TKP_Pagi;
Retrieved from "https://kangtain.com/wiki/index.php?title=Pengantar_Bahasa_Query:Tugas_1&oldid=7113"