ASSALAMUALAIKUM WR WB
SELAMAT DATANG DI BLOG SAYA!!
KALI INI SAYA AKAN MEMBERIKAN CONTOH MEMBUAT TABEL SEDERHANA DI CMD(COMMAND PROMT)
Command promt
YANG DI TULIS YANG BERWARNA YA !!!
Microsoft Windows [Version 10.0.16299.125]
(c) 2017 Microsoft Corporation. All rights
reserved.
C:\Users\USER>cd..
C:\Users>cd..
C:\>cd xampp
C:\xampp>cd mysql
C:\xampp\mysql>cd bin
C:\xampp\mysql\bin>mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.3.16-MariaDB mariadb.org
binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB
Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to
clear the current input statement.
MariaDB [(none)]> create database siswa;
Query OK, 1 row affected (0.008 sec)
MariaDB [(none)]> use siswa;
Database changed
MariaDB [siswa]> create table absen(
-> NISN int,
->nama varchar (40) not null,
->tgl_lahirvarchar(12),
->tempat_lahirvarchar(20),
-> primary key (NISN)
-> );
Query OK, 0 rows affected (0.408 sec)
MariaDB [siswa]> insert into absen
(NISN,nama,tgl_lahir,tempat_lahir)values(2468,'ahmad ansori','22/01/2003','jepara');
Query OK, 1 row affected (0.118 sec)
MariaDB [siswa]> select * from absen;
+------+--------------+------------+--------------+
| NISN | nama | tgl_lahir |tempat_lahir |
+------+--------------+------------+--------------+
| 2468 | ahmadansori | 22/01/2003 |
jepara |
+------+--------------+------------+--------------+
1 row in set (0.001 sec)
MariaDB [siswa]> insert into absen
(NISN,nama,tgl_lahir,tempat_lahir)values(2319,'taufik
umar','27/02/2002','jepara');
MariaDB [siswa]> insert into absen
(NISN,nama,tgl_lahir,tempat_lahir)values(2286,'abellindo
faustin','06/06/2003','jepara');
MariaDB [siswa]> insert into absen
(NISN,nama,tgl_lahir,tempat_lahir)values(2236,'MUHAMMAD DAFFANIO
WARDHANA','21/10/2002','jepara');
MariaDB [siswa]> insert into absen
(NISN,nama,tgl_lahir,tempat_lahir)values(2237,'MUHAMMAD KHUSNI
MUBAROH','01/10/2001','jepara');
Query OK, 1 row affected (0.082 sec)
MariaDB [siswa]> select * from absen;
+------+----------------------------+------------+--------------+
| NISN | nama | tgl_lahir |tempat_lahir |
+------+----------------------------+------------+--------------+
| 2236 | MUHAMMAD DAFFANIO WARDHANA |
21/10/2002 | jepara |
| 2237 | MUHAMMAD KHUSNI MUBAROH | 01/10/2001 | jepara |
| 2286 | abellindofaustin | 06/06/2003 | jepara |
| 2288 | ahmadansori | 22/01/2003 | jepara |
| 2319 | taufikumar | 27/02/2002 | jepara |
| 2468 | ahmadansori | 22/01/2003 | jepara |
+------+----------------------------+------------+--------------+
6 rows in set (0.001 sec)
MariaDB [siswa]>
 |
| DAN INI HASILNYA!!! |
NOTE : Contoh Tulisan yg diisikan yg berwarna
JIKA ADA KESALAHAN MOHON DI MAAFKAN
SEKIAN DAN TERIMAKASIH
