Pengantar Bahasa Query:Tugas 1: Difference between revisions
Created page with " CREATE DATABASE mustain_db; use mustain_db; CREATE TABLE nama( -> npm char(15), -> nama char(30), -> kota_asal char(20), -> tgl_lahir datetime, -> umur real -> );" |
No edit summary |
||
| Line 8: | Line 8: | ||
-> kota_asal char(20), | -> kota_asal char(20), | ||
-> tgl_lahir datetime, | -> tgl_lahir datetime, | ||
-> jenjang char(2), | |||
-> umur real | -> umur real | ||
-> ); | -> ); | ||
SHOW TABLES; | |||
Revision as of 12:11, 2 February 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;