Pengantar Bahasa Query:Tugas 1: Difference between revisions
No edit summary |
No edit summary |
||
| Line 13: | Line 13: | ||
SHOW TABLES; | SHOW TABLES; | ||
INSERT INTO nama (123456, Mustain, Semarang, 10/10/2000, S1, 22); | |||
Revision as of 12:19, 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;
INSERT INTO nama (123456, Mustain, Semarang, 10/10/2000, S1, 22);