Pengantar Bahasa Query:Tugas 1: Difference between revisions
m Kangtain moved page Pengantar Bahasa Query:Tugas 1 to Materi/Pengantar Bahasa Query/Tugas 1 |
No edit summary |
||
| Line 1: | Line 1: | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
CREATE DATABASE mustain_db; | CREATE DATABASE mustain_db; | ||
</syntaxhighlight> | |||
<syntaxhighlight lang="sql"> | |||
use mustain_db; | use mustain_db; | ||
</syntaxhighlight> | |||
<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 lang="sql"> | |||
SHOW TABLES; | SHOW TABLES; | ||
</syntaxhighlight> | |||
<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> | ||
{{DISPLAYTITLE:Open Database Connectivity}} | |||
Revision as of 17:01, 4 September 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;