Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Setting environment for using XAMPP for Windows.
- LENOVO@DESKTOP-S6731P1 c:\xamp
- # color a
- LENOVO@DESKTOP-S6731P1 c:\xamp
- # mysql -u root -p
- Enter password:
- Welcome to the MariaDB monitor. Commands end with ; or \g.
- Your MariaDB connection id is 1023
- Server version: 10.4.24-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 schools;
- Query OK, 1 row affected (0.476 sec)
- MariaDB [(none)]> use schools;
- Database changed
- MariaDB [schools]> create table majors(ID int primary key auto_increment, NISN int(100) not null, Nama_Lengkap varchar(100) not null);
- Query OK, 0 rows affected (12.413 sec)
- MariaDB [schools]> create table groups(ID int primary key auto_increment, Jenjang varchar(10) not null, Jurusan varchar(20) not null);
- Query OK, 0 rows affected (3.726 sec)
- MariaDB [schools]> create table Students(ID int primary key auto_increment, Lolos_Jalur varchar(255) not null, Alamat varchar(255) not null);
- Query OK, 0 rows affected (3.531 sec)
- MariaDB [schools]> alter table majors add column Jenis_Kelamin varchar(50) not null after Nama_Lengkap;
- Query OK, 0 rows affected (1.102 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- MariaDB [schools]> insert into majors values(null, '20221410.215544.00', 'Revi Nur Yunita', 'Perempuan');
- Query OK, 1 row affected, 1 warning (1.466 sec)
- MariaDB [schools]> insert into majors values(null, '20221410.215544.01', 'Muhammad Ihsan Nuril A', 'Laki-Laki');
- Query OK, 1 row affected, 1 warning (0.465 sec)
- MariaDB [schools]> insert into majors values(null, '20221410.215544.01', 'Nadira Arevia Hermawan', 'Perempuan');
- Query OK, 1 row affected, 1 warning (0.537 sec)
- MariaDB [schools]> delete from majors where id = 2;
- Query OK, 1 row affected (1.506 sec)
- MariaDB [schools]> delete from majors where id = 3;
- Query OK, 1 row affected (0.708 sec)
- MariaDB [schools]> insert into majors values(null, '20221410.215544.02', 'Nadira Arevia Hermawan', 'Perempuan');
- Query OK, 1 row affected, 1 warning (0.311 sec)
- MariaDB [schools]> insert into groups values(null, 'XII', 'Rekayasa Perangkat Lunak');
- Query OK, 1 row affected, 1 warning (0.412 sec)
- MariaDB [schools]> insert into groups values(null, 'XII', 'Kontark Mekanik B');
- Query OK, 1 row affected (0.420 sec)
- MariaDB [schools]> insert into groups values(null, 'XII', 'Kontrol Proses A');
- Query OK, 1 row affected (0.509 sec)
- MariaDB [schools]> insert into students values(null, 'SNMPTN', 'Jl.Semangka No.12');
- Query OK, 1 row affected (1.501 sec)
- MariaDB [schools]> insert into students values(null, 'SNMPTN', 'Jl.Melon Gg.10');
- Query OK, 1 row affected (0.375 sec)
- MariaDB [schools]> insert into students values(null, 'SNMPTN', 'Jl.Degan Blok.AB');
- Query OK, 1 row affected (0.128 sec)
- MariaDB [schools]> select * from majors;
- +----+------------+------------------------+---------------+
- | ID | NISN | Nama_Lengkap | Jenis_Kelamin |
- +----+------------+------------------------+---------------+
- | 1 | 2147483647 | Revi Nur Yunita | Perempuan |
- | 4 | 2147483647 | Nadira Arevia Hermawan | Perempuan |
- +----+------------+------------------------+---------------+
- 2 rows in set (0.107 sec)
- MariaDB [schools]> select * from groups;
- +----+---------+----------------------+
- | ID | Jenjang | Jurusan |
- +----+---------+----------------------+
- | 1 | XII | Rekayasa Perangkat L |
- | 2 | XII | Kontark Mekanik B |
- | 3 | XII | Kontrol Proses A |
- +----+---------+----------------------+
- 3 rows in set (0.001 sec)
- MariaDB [schools]> select * from students;
- +----+-------------+-------------------+
- | ID | Lolos_Jalur | Alamat |
- +----+-------------+-------------------+
- | 1 | SNMPTN | Jl.Semangka No.12 |
- | 2 | SNMPTN | Jl.Melon Gg.10 |
- | 3 | SNMPTN | Jl.Degan Blok.AB |
- +----+-------------+-------------------+
- 3 rows in set (0.564 sec)
- MariaDB [schools]> insert into majors values(null, '20221410.215544.01', 'Muhammad Ihsan Nuril A', 'Laki-Laki');
- Query OK, 1 row affected, 1 warning (0.601 sec)
- MariaDB [schools]> select * from majors;
- +----+------------+------------------------+---------------+
- | ID | NISN | Nama_Lengkap | Jenis_Kelamin |
- +----+------------+------------------------+---------------+
- | 1 | 2147483647 | Revi Nur Yunita | Perempuan |
- | 4 | 2147483647 | Nadira Arevia Hermawan | Perempuan |
- | 5 | 2147483647 | Muhammad Ihsan Nuril A | Laki-Laki |
- +----+------------+------------------------+---------------+
- 3 rows in set (0.001 sec)
- MariaDB [schools]> desc majors;
- +---------------+--------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +---------------+--------------+------+-----+---------+----------------+
- | ID | int(11) | NO | PRI | NULL | auto_increment |
- | NISN | int(100) | NO | | NULL | |
- | Nama_Lengkap | varchar(100) | NO | | NULL | |
- | Jenis_Kelamin | varchar(50) | NO | | NULL | |
- +---------------+--------------+------+-----+---------+----------------+
- 4 rows in set (2.643 sec)
- MariaDB [schools]> desc groups;
- +---------+-------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +---------+-------------+------+-----+---------+----------------+
- | ID | int(11) | NO | PRI | NULL | auto_increment |
- | Jenjang | varchar(10) | NO | | NULL | |
- | Jurusan | varchar(20) | NO | | NULL | |
- +---------+-------------+------+-----+---------+----------------+
- 3 rows in set (0.347 sec)
- MariaDB [schools]> desc students;
- +-------------+--------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +-------------+--------------+------+-----+---------+----------------+
- | ID | int(11) | NO | PRI | NULL | auto_increment |
- | Lolos_Jalur | varchar(255) | NO | | NULL | |
- | Alamat | varchar(255) | NO | | NULL | |
- +-------------+--------------+------+-----+---------+----------------+
- 3 rows in set (0.046 sec)
- MariaDB [schools]> select s.Nama_Lengkap as Nama_Lengkap, s.Jenis_Kelamin Jenis_Kelamin, j.Jenjang as Jenjang, m.Lolos_Jalur as Lolos_Jalur, m.Alamat as Alamat from majors as s join groups as j on s.ID=j.ID join students as m on j.ID=m.ID;
- +-----------------+---------------+---------+-------------+-------------------+
- | Nama_Lengkap | Jenis_Kelamin | Jenjang | Lolos_Jalur | Alamat |
- +-----------------+---------------+---------+-------------+-------------------+
- | Revi Nur Yunita | Perempuan | XII | SNMPTN | Jl.Semangka No.12 |
- +-----------------+---------------+---------+-------------+-------------------+
- 1 row in set (0.224 sec)
- MariaDB [schools]>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement