Pengantar Bahasa Query:Tugas 1: Difference between revisions

@@ Line 1: / Line 1: @@
- CREATE DATABASE mustain_db;
+<syntaxhighlight lang="sql">
+CREATE DATABASE mustain_db;
- use mustain_db;
+</syntaxhighlight><syntaxhighlight lang="sql">
+use mustain_db;
- CREATE TABLE nama(
+</syntaxhighlight><syntaxhighlight lang="sql">
-    -> npm char(15),
+CREATE TABLE nama(
-    -> nama char(30),
+   -> npm char(15),
-    -> kota_asal char(20),
+   -> nama char(30),
-    -> tgl_lahir datetime,
+   -> kota_asal char(20),
-    -> jenjang char(2),
+   -> tgl_lahir datetime,
-    -> umur real
+   -> jenjang char(2),
-    -> );
+   -> umur real
+   -> );
- SHOW TABLES;
+</syntaxhighlight><syntaxhighlight lang="sql">
+SHOW TABLES;
- INSERT INTO nama (npm, nama, kota_asal, tgl_lahir, jenjang, umur)
+</syntaxhighlight><syntaxhighlight lang="sql">
-     -> values
+INSERT INTO nama (npm, nama, kota_asal, tgl_lahir, jenjang, umur)
-     -> ('625374987','Mustain','Semarang','2000-09-20','S1','22');
+    -> values
+    -> ('625374987','Mustain','Semarang','2000-09-20','S1','22');
-Atau
+</syntaxhighlight>Atau
   INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur)
       -> values