Pengantar Bahasa Query:Tugas 1: Difference between revisions
No edit summary |
No edit summary |
||
| Line 22: | Line 22: | ||
-> values | -> values | ||
-> ('625374987','Mustain','Semarang','2000-09-20','S1','22'); | -> ('625374987','Mustain','Semarang','2000-09-20','S1','22'); | ||
</syntaxhighlight>Atau | </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> | |||
Memperlihatkan Field yang sudah di input | |||
Revision as of 02:14, 23 August 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;