Jump to content

Pengantar Bahasa Query:Tugas 1: Difference between revisions

From Wiki
← Older editNewer edit →
Kangtain (talk | contribs)
Bureaucrats, Interface administrators, Suppressors, Administrators
9,154 edits
VisualWikitext
No edit summary
No edit summary
Line 14: Line 14:
  SHOW TABLES;
  SHOW TABLES;


  INSERT INTO nama (123456, Mustain, Semarang, 10/10/2000, S1, 22);
  INSERT INTO nama (npm, nama, kota_asal, tgl_lahir, jenjang, umur)

Revision as of 12:25, 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 (npm, nama, kota_asal, tgl_lahir, jenjang, umur)
Retrieved from "https://kangtain.com/wiki/index.php?title=Pengantar_Bahasa_Query:Tugas_1&oldid=3222"