Contoh Membuat tabel di CMD(command promt).

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