Microsoft Windows [Version 10.0.19045.

2965]
(c) Microsoft Corporation. All rights reserved.

C:\Users\LENOVO THINKPAD T470>cd..

C:\Users>cd..

C:\>cd mysql
The system cannot find the path specified.

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 10
Server version: 10.4.28-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 Penerima_Mahasiswa_Baru;

Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> use Penerima_Mahasiswa_Baru;

Database changed
MariaDB [Penerima_Mahasiswa_Baru]> create table jurusan(
-> ID_Jurusan varchar(10)primery key,
-> Nama_Jurusan varchar (25));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'key,
Nama_Jurusan varchar (25))' at line 2
MariaDB [Penerima_Mahasiswa_Baru]> create table jurusan(
-> ID_Jurusan varchar(10)primary key,
-> Nama_Jurusan varchar (25));
Query OK, 0 rows affected (0.270 sec)

MariaDB [Penerima_Mahasiswa_Baru]> desc jurusan;

+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| ID_Jurusan | varchar(10) | NO | PRI | NULL | |
| Nama_Jurusan | varchar(25) | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
2 rows in set (0.008 sec)

MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO 'jurusan' ('ID_Jurusan',

'Nama_Jurusan') VALUES
-> ('TI', 'Teknologi Informasi'),
-> ('AB', 'Administarasi Bisnis'),
-> ('AK', 'Akutansi'),
-> ('DKF', 'Design Komunikasi Fisual'),
-> ('IK', 'Ilmu Komunikasi'),
-> ('SI', 'Sistem Informasi'),
-> ('TE', 'Teknik Elektro'),
 -> ('TK', 'Teknologi Komputer'),
-> ('KD', 'Kedokteran'),
-> ('MN', 'Management'),
-> ('RPL', 'Rekayasa Perangkat Lunak');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
''jurusan' ('ID_Jurusan', 'Nama_Jurusan') VALUES
('TI', 'Teknologi Informasi')...' at line 1
MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO jurusan ('ID_Jurusan',
'Nama_Jurusan') VALUES
-> ('TI', 'Teknologi Informasi'),
-> ('AB', 'Administarasi Bisnis'),
-> ('AK', 'Akutansi'),
-> ('DKF', 'Design Komunikasi Fisual'),
-> ('IK', 'Ilmu Komunikasi'),
-> ('SI', 'Sistem Informasi'),
-> ('TE', 'Teknik Elektro'),
-> ('TK', 'Teknologi Komputer'),
-> ('KD', 'Kedokteran'),
-> ('MN', 'Management'),
-> ('RPL', 'Rekayasa Perangkat Lunak');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
''ID_Jurusan', 'Nama_Jurusan') VALUES
('TI', 'Teknologi Informasi'),
('AB', 'A...' at line 1
MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO jurusan (ID_Jurusan, Nama_Jurusan)
VALUES
-> ('TI', 'Teknologi Informasi'),
-> ('AB', 'Administarasi Bisnis'),
-> ('AK', 'Akutansi'),
-> ('DKF', 'Design Komunikasi Fisual'),
-> ('IK', 'Ilmu Komunikasi'),
-> ('SI', 'Sistem Informasi'),
-> ('TE', 'Teknik Elektro'),
-> ('TK', 'Teknologi Komputer'),
-> ('KD', 'Kedokteran'),
-> ('MN', 'Management'),
-> ('RPL', 'Rekayasa Perangkat Lunak');
Query OK, 11 rows affected (0.012 sec)
Records: 11 Duplicates: 0 Warnings: 0

MariaDB [Penerima_Mahasiswa_Baru]> select*from jurusan;

+------------+--------------------------+
| ID_Jurusan | Nama_Jurusan |
+------------+--------------------------+
| AB | Administarasi Bisnis |
| AK | Akutansi |
| DKF | Design Komunikasi Fisual |
| IK | Ilmu Komunikasi |
| KD | Kedokteran |
| MN | Management |
| RPL | Rekayasa Perangkat Lunak |
| SI | Sistem Informasi |
| TE | Teknik Elektro |
| TI | Teknologi Informasi |
| TK | Teknologi Komputer |
+------------+--------------------------+
11 rows in set (0.000 sec)
MariaDB [Penerima_Mahasiswa_Baru]> create table peserta(
-> ID_Peserta(
-> Nama_Peserta varchar(25)),
-> Nama_Peserta varchar(25),
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '(
Nama_Peserta varchar(25)),
Nama_Peserta varchar(25),' at line 2
MariaDB [Penerima_Mahasiswa_Baru]> create table peserta(
-> ID_Peserta(
-> Nama_Peserta varchar(25),
-> Alamat varchar(25),
-> ID_Jurusan varchar(10),
-> Foreign key (ID_Jurusan) references jurusan (ID_Jurusan));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '(
Nama_Peserta varchar(25),
Alamat varchar(25),
ID_Jurusan varchar(10),
Forei...' at line 2
MariaDB [Penerima_Mahasiswa_Baru]> create table peserta(
-> ID_Peserta(
-> Nama_Peserta varchar (25),
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '(
Nama_Peserta varchar (25),' at line 2
MariaDB [Penerima_Mahasiswa_Baru]> create table peserta(
-> ID_Peserta varchar (10)primary key,
-> Nama_Peserta varchar (25),
-> Alamat varchar (25),
-> ID_Jurusan varchar (10),
-> Foreign key (ID_Jurusan) references jurusan (ID_Jurusan));
Query OK, 0 rows affected (0.018 sec)

MariaDB [Penerima_Mahasiswa_Baru]> desc peserta;

+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| ID_Peserta | varchar(10) | NO | PRI | NULL | |
| Nama_Peserta | varchar(25) | YES | | NULL | |
| Alamat | varchar(25) | YES | | NULL | |
| ID_Jurusan | varchar(10) | YES | MUL | NULL | |
+--------------+-------------+------+-----+---------+-------+
4 rows in set (0.008 sec)

MariaDB [Penerima_Mahasiswa_Baru]> create table melakukan(

-> ID_Peserta varchar (10),
-> ID_Tes varchar (10),
-> Hasil varchar (20),
-> Nilai int (10),
-> Ranking varchar (15));
Query OK, 0 rows affected (0.016 sec)

MariaDB [Penerima_Mahasiswa_Baru]> desc melakukan;

+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| ID_Peserta | varchar(10) | YES | | NULL | |
| ID_Tes | varchar(10) | YES | | NULL | |
| Hasil | varchar(20) | YES | | NULL | |
| Nilai | int(10) | YES | | NULL | |
| Ranking | varchar(15) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.009 sec)

MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO melakukan (ID_Peserta, ID_Tes,

Hasil, Nilai, Ranking) VALUES
-> ('A10', 'U0101', 'DI TERIMA', 500, 'SATU'),
-> ('A11', 'U0102', 'DI TERIMA', 478, 'SATU'),
-> ('A12', 'U0103', 'TIDAK TERIMA', 150, 'SATU'),
-> ('A12', 'U0104', 'TIDAK TERIMA', 120, 'SATU'),
-> ('A14', 'U0105', 'DI TERIMA', 470, 'DUA'),
-> ('A15', 'U0106', 'DI TERIMA', 300, 'SEPULUH'),
-> ('A16', 'U0107', 'DI TERIMA', 400, 'TUJUH'),
-> ('A17', 'U0108', 'TIDAK TERIMA', 100, ''),
-> ('A17', 'U0108', 'DI TERIMA', 400, 'DELAPAN'),
-> ('A18', 'U01010', 'DI TERIMA', 440, 'SATU'),
-> ('A20', 'U01010', 'DI TERIMA', 460, 'TIGA');
Query OK, 11 rows affected (0.271 sec)
Records: 11 Duplicates: 0 Warnings: 0

MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO panitia (ID_Peserta, ID_Tes,

Nama_Panitia, Jabatan) VALUES
-> ('001JP', 'JPU'),
-> ('002BS', 'BEASISWA'),
-> ('10CB', 'CBT'),
-> ('10UT', 'UTG');
ERROR 1146 (42S02): Table 'penerima_mahasiswa_baru.panitia' doesn't exist
MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO panitia (ID_Peserta, ID_Tes,
Nama_Panitia, Jabatan) VALUES
-> ('PN201', 'U0101', 'Rama', 'Ketua'),
-> ('PN2011', 'U01011', 'Reski', 'Acara'),
-> ('PN202', 'U0102', 'Indah', 'Wakil'),
-> ('PN203', 'U0103', 'Dita', 'Keamanan'),
-> ('PN204', 'U0104', 'Vita', 'Pubdok'),
-> ('PN205', 'U0105', 'Daffa', 'Humas'),
-> ('PN206', 'U0106', 'Ari', 'Acara'),
-> ('PN207', 'U0107', 'Ajis', 'Keamanan'),
-> ('PN208', 'U0107', 'Aji', 'Pubdok'),
-> ('PN209', 'U0109', 'Abii', 'Humas');
ERROR 1146 (42S02): Table 'penerima_mahasiswa_baru.panitia' doesn't exist
MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO peserta (ID_Peserta, Nama_Peserta,
Alamat, Id_Jurusan) VALUES
-> ('A10', 'Rifki', 'Bone', 'Tk67'),
-> ('A11', 'Dita', 'Padang', 'AK16'),
-> ('A12', 'Fadel', 'Palopo', 'MBT'),
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '' at
line 4
MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO peserta (ID_Peserta, Nama_Peserta,
Alamat, Id_Jurusan) VALUES
-> ('A10', 'Rifki', 'Bone', 'TI'),
-> ('A11', 'Dita', 'Padang', 'AK'),
-> ('A12', 'Fadel', 'Palopo', 'SI'),
 -> ('A13', 'Indah', 'Sorong', 'AB'),
-> ('A14', 'Vitta', 'Bandung', 'IK'),
-> ('A15', 'Reza', 'Jakarta', 'TK'),
-> ('A16', 'Aji', 'Bandung', 'KD'),
-> ('A17', 'Ari', 'Bandung', 'MN'),
-> ('A18', 'Abi', 'Banten', 'RPL'),
-> ('A19', 'Azis', 'Tangerang', 'DKF');
Query OK, 10 rows affected (0.061 sec)
Records: 10 Duplicates: 0 Warnings: 0

MariaDB [Penerima_Mahasiswa_Baru]> select*from peserta;

+------------+--------------+-----------+------------+
| ID_Peserta | Nama_Peserta | Alamat | ID_Jurusan |
+------------+--------------+-----------+------------+
| A10 | Rifki | Bone | TI |
| A11 | Dita | Padang | AK |
| A12 | Fadel | Palopo | SI |
| A13 | Indah | Sorong | AB |
| A14 | Vitta | Bandung | IK |
| A15 | Reza | Jakarta | TK |
| A16 | Aji | Bandung | KD |
| A17 | Ari | Bandung | MN |
| A18 | Abi | Banten | RPL |
| A19 | Azis | Tangerang | DKF |
+------------+--------------+-----------+------------+
10 rows in set (0.001 sec)

MariaDB [Penerima_Mahasiswa_Baru]> create table tes;

ERROR 1113 (42000): A table must have at least 1 column
MariaDB [Penerima_Mahasiswa_Baru]> create table Tes;
ERROR 1113 (42000): A table must have at least 1 column
MariaDB [Penerima_Mahasiswa_Baru]> create table Jenis_Tes(
-> ID_Jenis_Tes varchar (10) primary key,
-> Nama_Tes varchar (20));
Query OK, 0 rows affected (0.027 sec)

MariaDB [Penerima_Mahasiswa_Baru]> desc Jenis_Tes;

+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| ID_Jenis_Tes | varchar(10) | NO | PRI | NULL | |
| Nama_Tes | varchar(20) | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
2 rows in set (0.012 sec)

MariaDB [Penerima_Mahasiswa_Baru]> create table panitia(

-> ID_Panitia varchar(10) primary key,
-> ID_Tes varchar (10),
-> Foreign key (ID_Tes) reference tes (ID_Tes),
-> Nama_Panitia varchar (25),
-> Jabatan varchar (25));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'reference tes (ID_Tes),
Nama_Panitia varchar (25),
Jabatan varchar (25))' at line 4
MariaDB [Penerima_Mahasiswa_Baru]> create table panitia(
-> ID_Panitia varchar(10) primary key,
-> ID_Tes varchar(10),
 -> Nama_Panitia varchar(25),
-> Jabatan varchar(25));
Query OK, 0 rows affected (0.021 sec)

MariaDB [Penerima_Mahasiswa_Baru]> desc panitia;

+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| ID_Panitia | varchar(10) | NO | PRI | NULL | |
| ID_Tes | varchar(10) | YES | | NULL | |
| Nama_Panitia | varchar(25) | YES | | NULL | |
| Jabatan | varchar(25) | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
4 rows in set (0.013 sec)

MariaDB [Penerima_Mahasiswa_Baru]> create table melakukan;

ERROR 1050 (42S01): Table 'melakukan' already exists
MariaDB [Penerima_Mahasiswa_Baru]> create table melakukan(
-> ID_Peserta varchar(10),
-> ID_Tes varchar(10),
-> Hasil varchar(20),
-> Nilai int(10),
-> Ranking varchar(15));
ERROR 1050 (42S01): Table 'melakukan' already exists
MariaDB [Penerima_Mahasiswa_Baru]> desc melakukan;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| ID_Peserta | varchar(10) | YES | | NULL | |
| ID_Tes | varchar(10) | YES | | NULL | |
| Hasil | varchar(20) | YES | | NULL | |
| Nilai | int(10) | YES | | NULL | |
| Ranking | varchar(15) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.014 sec)

MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO panitia (ID_Panitia, ID_Tes,

Nama_Panitia, Jabatan) VALUES
-> ('PN201', 'U0101', 'Vita', 'Ketua'),
-> ('PN202', 'U0102', 'Rama', 'Acara'),
-> ('PN203', 'U0103', 'Indah', 'Wakil'),
-> ('PN204', 'U0104', 'Azis', 'Keamanan'),
-> ('PN205', 'U0105', 'Aji', 'Pubdok'),
-> ('PN206', 'U0106', 'Abi', 'Humas');
Query OK, 6 rows affected (0.056 sec)
Records: 6 Duplicates: 0 Warnings: 0

MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO jenis_tes (ID_Jenis_Tes, Nama_Tes)

VALUES
-> ('001JP', 'JPU'),
-> ('002BS', 'BEASISWA'),
-> ('10CB', 'CBT'),
-> ('10UT', 'UTG');
Query OK, 4 rows affected (0.005 sec)
Records: 4 Duplicates: 0 Warnings: 0

MariaDB [Penerima_Mahasiswa_Baru]> create table tes(

-> ID_Tes varchar (10) primary key,
-> ID_Jenis_Tes varchar (10),
 -> ruang varchar (20)
-> ruang varchar (20),
-> Tanggal_Tes date);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'varchar (20),
Tanggal_Tes date)' at line 5
MariaDB [Penerima_Mahasiswa_Baru]> create table tes(
-> ID_Tes varchar (10) primary key,
-> ID_Jenis_Tes varchar (10),
-> ruang varchar (20),
-> Tanggal_Tes date);
Query OK, 0 rows affected (0.023 sec)

MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO tes ('ID_Tes', ID_Jenis_Tes',

'Ruang', 'Tanggal_Tes) VALUES
-> ('IU0101', '10UT', 'A1, '2020-01-01'),
'> ('IU1010', '002BS', 'A4, '2020-01-04'),
-> ('IU1011', '10UT', 'A1, '2020-01-01'),
'> ('IU102', '10CB', 'A2', '2020-01-01'),
'> ('IU103', '10AB', 'A3', '2020-01-04');
'> ;
'> -;
'> INSERT INTO tes ('ID_Tes', ID_Jenis_Tes', 'Ruang', 'Tanggal_Tes) VALUES
'> ('IU0101', '10UT', 'A1', '2020-01-01'),
'> );
'> ('IU0101', '10UT', 'A1', '2020-01-01'));
'> ('IU0101', '10UT', 'A1', '2020-01-01');
'> vvhjvjg
'> ;
'> INSERT INTO tes ('ID_Tes', ID_Jenis_Tes', 'Ruang', 'Tanggal_Tes) VALUES
'> Ctrl-C -- exit!
Bye

C:\xampp\mysql\bin>mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 10.4.28-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)]> INSERT INTO tes ('ID_Tes', ID_Jenis_Tes', 'Ruang', 'Tanggal_Tes)

VALUES
-> ('IU1011', '10UT', 'A1', '2020-01-01'),
-> ('IU103', '10AB', 'A3', '2020-01-04'),
-> ('IU0104', '10UB', 'A4', '2020-01-01'),
-> ('IU0102', '10UB', 'A2', '2020-01-04'),
-> ('IU0103', '10UA', 'A5', '2020-01-01');
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> Ctrl-C -- exit!
Bye

C:\xampp\mysql\bin>mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 12
Server version: 10.4.28-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)]> USE Penerima_Mahasiswa_Baru;

Database changed
MariaDB [Penerima_Mahasiswa_Baru]> show databases;
+---------------------------+
| Database |
+---------------------------+
| information_schema |
| mysql |
| penerima_mahasiswa_baru |
| penerimaan_mahasiswa_baru |
| performance_schema |
| phpmyadmin |
| sip_karyawan_1 |
| sip_karyawan_2 |
| test |
| ubsi |
+---------------------------+
10 rows in set (0.002 sec)

MariaDB [Penerima_Mahasiswa_Baru]> USE Penerimaan_Mahasiswa_Baru;

Database changed
MariaDB [Penerimaan_Mahasiswa_Baru]> show Penerimaan_Mahasiswa_Baru;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'Penerimaan_Mahasiswa_Baru' at line 1
MariaDB [Penerimaan_Mahasiswa_Baru]> describe Penerimaan_Mahasiswa_Baru;
ERROR 1146 (42S02): Table 'penerimaan_mahasiswa_baru.penerimaan_mahasiswa_baru'
doesn't exist
MariaDB [Penerimaan_Mahasiswa_Baru]> show databases
-> ;
+---------------------------+
| Database |
+---------------------------+
| information_schema |
| mysql |
| penerima_mahasiswa_baru |
| penerimaan_mahasiswa_baru |
| performance_schema |
| phpmyadmin |
| sip_karyawan_1 |
| sip_karyawan_2 |
| test |
| ubsi |
+---------------------------+
10 rows in set (0.001 sec)

MariaDB [Penerimaan_Mahasiswa_Baru]> INSERT INTO tes ('ID_Tes', ID_Jenis_Tes',

'Ruang', 'Tanggal_Tes) VALUES
-> ('IU0101', '10UT', 'A1', '2020-01-01');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
''ID_Tes', ID_Jenis_Tes', 'Ruang', 'Tanggal_Tes) VALUES
('IU0101', '10UT', 'A1...' at line 1
MariaDB [Penerimaan_Mahasiswa_Baru]> INSERT INTO tes ('ID_Tes', ID_Jenis_Tes',
'Ruang', 'Tanggal_Tes) VALUES
 -> ('IU103', '10AB', 'A3', '2020-01-04'),
-> ('IU0103', '10UA', 'A5', '2020-01-01'),
-> ('IU0104', '10UI', 'A4', '2020-01-04'),
-> ('IU0103', '10UB', 'A3', '2020-01-01'),
-> ('IU0101', '10UT', 'A1', '2020-01-04');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
''ID_Tes', ID_Jenis_Tes', 'Ruang', 'Tanggal_Tes) VALUES
('IU103', '10AB', 'A3'...' at line 1
MariaDB [Penerimaan_Mahasiswa_Baru]> INSERT INTO tes ('ID_Tes','ID_Jenis_Tes',
'Ruang', 'Tanggal_Tes') VALUES
-> ('IU1013', '10AB', 'A3', '2020-01-04'),
-> ('IU0101', '10UT', 'A1', '2020-01-04');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
''ID_Tes','ID_Jenis_Tes', 'Ruang', 'Tanggal_Tes') VALUES
('IU1013', '10AB', 'A...' at line 1
MariaDB [Penerimaan_Mahasiswa_Baru]> INSERT INTO tes (ID_Tes, ID_Jenis_Tes, Ruang,
Tanggal_Tes) VALUES
-> ('IU1013', '10AB', 'A3', '2020-01-04'),
-> ('IU0101', '10UT', 'A1', '2020-01-04');
ERROR 1146 (42S02): Table 'penerimaan_mahasiswa_baru.tes' doesn't exist
MariaDB [Penerimaan_Mahasiswa_Baru]> INSERT INTO tes (ID_Tes, ID_Jenis_Tes, Ruang,
Tanggal_Tes) VALUES
-> ('IU1013', '10AB', 'A3', '2020-01-04'),
-> ('IU0101', '10UT', 'A1', '2020-01-04'),
-> ('IU0104', '10UI', 'A4', '2020-01-04'),
-> ('IU0103', '10UA', 'A5', '2020-01-01'),
-> ('IU0102', '10UB', 'A2', '2020-01-01');
ERROR 1146 (42S02): Table 'penerimaan_mahasiswa_baru.tes' doesn't exist
MariaDB [Penerimaan_Mahasiswa_Baru]> create table tes;
ERROR 1113 (42000): A table must have at least 1 column
MariaDB [Penerimaan_Mahasiswa_Baru]> create table tes(
-> ID_Tes varchar (10) primary key,
-> ID_Jenis_Tes varchar (10),
-> Ruang varchar (20),
-> Tanggal_Tes date);
Query OK, 0 rows affected (0.250 sec)

MariaDB [Penerimaan_Mahasiswa_Baru]> INSERT INTO tes (ID_Tes, ID_Jenis_Tes, Ruang,

Tanggal_Tes) VALUES
-> ('IU0103', '10UA', 'A5', '2020-01-01'),
-> ('IU0104', '10UI', 'A4', '2020-01-04'),
-> ('IU0103', '10UB', 'A3', '2020-01-01'),
-> ('IU0101', '10UT', 'A1', '2020-01-04');
ERROR 1062 (23000): Duplicate entry 'IU0103' for key 'PRIMARY'
MariaDB [Penerimaan_Mahasiswa_Baru]> INSERT INTO tes (ID_Tes, ID_Jenis_Tes, Ruang,
Tanggal_Tes) VALUES
-> ('IU1013', '10AB', 'A3', '2020-01-04'),
-> ('IU0103', '10UA', 'A5', '2020-01-01'),
-> ('IU0102', '10UB', 'A2', '2020-01-01');
Query OK, 3 rows affected (0.236 sec)
Records: 3 Duplicates: 0 Warnings: 0

MariaDB [Penerimaan_Mahasiswa_Baru]> desc melakukan;

ERROR 1146 (42S02): Table 'penerimaan_mahasiswa_baru.melakukan' doesn't exist
MariaDB [Penerimaan_Mahasiswa_Baru]> create table melakukan;
ERROR 1113 (42000): A table must have at least 1 column
MariaDB [Penerimaan_Mahasiswa_Baru]> show table melakukan
 -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'melakukan' at line 1
MariaDB [Penerimaan_Mahasiswa_Baru]> show table melakukan;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'melakukan' at line 1
MariaDB [Penerimaan_Mahasiswa_Baru]> desc table melakukan;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'table
melakukan' at line 1
MariaDB [Penerimaan_Mahasiswa_Baru]> desc melakukan;
ERROR 1146 (42S02): Table 'penerimaan_mahasiswa_baru.melakukan' doesn't exist
MariaDB [Penerimaan_Mahasiswa_Baru]> select*from melakukan;
ERROR 1146 (42S02): Table 'penerimaan_mahasiswa_baru.melakukan' doesn't exist
MariaDB [Penerimaan_Mahasiswa_Baru]> create table melakukan(
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '' at
line 1
MariaDB [Penerimaan_Mahasiswa_Baru]> mysql -u root
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'mysql
-u root' at line 1
MariaDB [Penerimaan_Mahasiswa_Baru]> Bye
Ctrl-C -- exit!

C:\xampp\mysql\bin>mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 13
Server version: 10.4.28-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)]> show databases

-> ;
+---------------------------+
| Database |
+---------------------------+
| information_schema |
| mysql |
| penerima_mahasiswa_baru |
| penerimaan_mahasiswa_baru |
| performance_schema |
| phpmyadmin |
| sip_karyawan_1 |
| sip_karyawan_2 |
| test |
| ubsi |
+---------------------------+
10 rows in set (0.002 sec)

MariaDB [(none)]> use Penerima_Mahasiswa_Baru;

Database changed
MariaDB [Penerima_Mahasiswa_Baru]> desc melakukan;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| ID_Peserta | varchar(10) | YES | | NULL | |
| ID_Tes | varchar(10) | YES | | NULL | |
| Hasil | varchar(20) | YES | | NULL | |
| Nilai | int(10) | YES | | NULL | |
| Ranking | varchar(15) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.010 sec)

MariaDB [Penerima_Mahasiswa_Baru]> desc tes

-> ;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| ID_Tes | varchar(10) | NO | PRI | NULL | |
| ID_Jenis_Tes | varchar(10) | YES | | NULL | |
| ruang | varchar(20) | YES | | NULL | |
| Tanggal_Tes | date | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
4 rows in set (0.013 sec)

MariaDB [Penerima_Mahasiswa_Baru]> desc panitia;

+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| ID_Panitia | varchar(10) | NO | PRI | NULL | |
| ID_Tes | varchar(10) | YES | | NULL | |
| Nama_Panitia | varchar(25) | YES | | NULL | |
| Jabatan | varchar(25) | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
4 rows in set (0.012 sec)

MariaDB [Penerima_Mahasiswa_Baru]> desc jurusan;

+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| ID_Jurusan | varchar(10) | NO | PRI | NULL | |
| Nama_Jurusan | varchar(25) | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
2 rows in set (0.009 sec)

MariaDB [Penerima_Mahasiswa_Baru]> select * from jurusan;

+------------+--------------------------+
| ID_Jurusan | Nama_Jurusan |
+------------+--------------------------+
| AB | Administarasi Bisnis |
| AK | Akutansi |
| DKF | Design Komunikasi Fisual |
| IK | Ilmu Komunikasi |
| KD | Kedokteran |
| MN | Management |
| RPL | Rekayasa Perangkat Lunak |
| SI | Sistem Informasi |
| TE | Teknik Elektro |
| TI | Teknologi Informasi |
| TK | Teknologi Komputer |
+------------+--------------------------+
11 rows in set (0.001 sec)

MariaDB [Penerima_Mahasiswa_Baru]> select * From panitia;

+------------+--------+--------------+----------+
| ID_Panitia | ID_Tes | Nama_Panitia | Jabatan |
+------------+--------+--------------+----------+
| PN201 | U0101 | Vita | Ketua |
| PN202 | U0102 | Rama | Acara |
| PN203 | U0103 | Indah | Wakil |
| PN204 | U0104 | Azis | Keamanan |
| PN205 | U0105 | Aji | Pubdok |
| PN206 | U0106 | Abi | Humas |
+------------+--------+--------------+----------+
6 rows in set (0.001 sec)

MariaDB [Penerima_Mahasiswa_Baru]> desc test;

ERROR 1146 (42S02): Table 'penerima_mahasiswa_baru.test' doesn't exist
MariaDB [Penerima_Mahasiswa_Baru]> desc tes;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| ID_Tes | varchar(10) | NO | PRI | NULL | |
| ID_Jenis_Tes | varchar(10) | YES | | NULL | |
| ruang | varchar(20) | YES | | NULL | |
| Tanggal_Tes | date | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
4 rows in set (0.009 sec)

MariaDB [Penerima_Mahasiswa_Baru]> select * from tes;

Empty set (0.000 sec)

MariaDB [Penerima_Mahasiswa_Baru]> INSERT INTO tes (ID_Tes, ID_Jenis_Tes, Ruang,

Tanggal_Tes) VALUES
-> ('IU1013', '10AB', 'A3', '2020-01-04'),
-> ('IU0101', '10UT', 'A1', '2020-01-04'),
-> ('IU0103', '10UA', 'A5', '2020-01-01'),
-> ('IU0104', '10UI', 'A4', '2020-01-01'),
-> ('IU0102', '10UE', 'A2', '2020-01-01');
Query OK, 5 rows affected (0.049 sec)
Records: 5 Duplicates: 0 Warnings: 0

MariaDB [Penerima_Mahasiswa_Baru]> select * form tes;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'form
tes' at line 1
MariaDB [Penerima_Mahasiswa_Baru]> select * from tes;
+--------+--------------+-------+-------------+
| ID_Tes | ID_Jenis_Tes | ruang | Tanggal_Tes |
+--------+--------------+-------+-------------+
| IU0101 | 10UT | A1 | 2020-01-04 |
| IU0102 | 10UE | A2 | 2020-01-01 |
| IU0103 | 10UA | A5 | 2020-01-01 |
| IU0104 | 10UI | A4 | 2020-01-01 |
| IU1013 | 10AB | A3 | 2020-01-04 |
+--------+--------------+-------+-------------+
5 rows in set (0.000 sec)

MariaDB [Penerima_Mahasiswa_Baru]> desc melakukan;

+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| ID_Peserta | varchar(10) | YES | | NULL | |
| ID_Tes | varchar(10) | YES | | NULL | |
| Hasil | varchar(20) | YES | | NULL | |
| Nilai | int(10) | YES | | NULL | |
| Ranking | varchar(15) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.006 sec)

MariaDB [Penerima_Mahasiswa_Baru]> select * From melakukan;

+------------+--------+--------------+-------+---------+
| ID_Peserta | ID_Tes | Hasil | Nilai | Ranking |
+------------+--------+--------------+-------+---------+
| A10 | U0101 | DI TERIMA | 500 | SATU |
| A11 | U0102 | DI TERIMA | 478 | SATU |
| A12 | U0103 | TIDAK TERIMA | 150 | SATU |
| A12 | U0104 | TIDAK TERIMA | 120 | SATU |
| A14 | U0105 | DI TERIMA | 470 | DUA |
| A15 | U0106 | DI TERIMA | 300 | SEPULUH |
| A16 | U0107 | DI TERIMA | 400 | TUJUH |
| A17 | U0108 | TIDAK TERIMA | 100 | |
| A17 | U0108 | DI TERIMA | 400 | DELAPAN |
| A18 | U01010 | DI TERIMA | 440 | SATU |
| A20 | U01010 | DI TERIMA | 460 | TIGA |
+------------+--------+--------------+-------+---------+
11 rows in set (0.001 sec)

MariaDB [Penerima_Mahasiswa_Baru]>