(c) 2019 Microsoft Corporation. All rights reserved.
C:\Users\4DR1>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 3
Server version: 10.1.31-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 POLTEKA ;
Query OK, 1 row affected (0.01 sec)
MariaDB [(none)]> USE POLTEKA ;
Database changed
MariaDB [POLTEKA]> CREATE TABLE POLTEKAD (
-> nrp varchar(50),
-> nama_bamasis varchar (50),
-> jenis_kelamin enum ("L",:P:),
-> satuan varchar (50),
-> primary key (nrp)
MariaDB [POLTEKA]> CREATE TABLE POLTEKAD (
-> nrp varchar (50),
-> nama_bamasis varchar (50),
-> jenis_kelamin enum ("L","P"),
-> satuan varchar (50),
-> primary key (nrp)
-> );
Query OK, 0 rows affected (1.38 sec)
MariaDB [POLTEKA]> INSERT INTO POLTEKAD
-> VALUES ("0123","ADRI","L","ARMED");
Query OK, 1 row affected (0.13 sec)
MariaDB [POLTEKA]> SELECT*FROM POLTEKAD;
+------+--------------+---------------+--------+
| nrp | nama_bamasis | jenis_kelamin | satuan |
+------+--------------+---------------+--------+
| 0123 | ADRI | L | ARMED |
+------+--------------+---------------+--------+
1 row in set (0.00 sec)
MariaDB [POLTEKA]>
