Scribd
Upload
85 views10 pages

Belajar CMD

The document shows the output of directory and file listings for the C:\xampp\mysql\bin folder on a system. It lists over 90 files and their sizes. It also shows attempts to run MySQL commands from the command line, but receiving an error since the path is not added to PATH.

Uploaded by

ibrahimahmadfalatin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
85 views10 pages

Belajar CMD

The document shows the output of directory and file listings for the C:\xampp\mysql\bin folder on a system. It lists over 90 files and their sizes. It also shows attempts to run MySQL commands from the command line, but receiving an error since the path is not added to PATH.

Uploaded by

ibrahimahmadfalatin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 10

Microsoft Windows [Version 10.0.22631.

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

C:\Users\TUF>cd\

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

C:\>cd xampp\mysql\bin

C:\xampp\mysql\bin>dir
Volume in drive C is OS
Volume Serial Number is E2D9-DA9E

Directory of C:\xampp\mysql\bin

22/10/2023 17:09 <DIR> .


22/10/2023 17:08 <DIR> ..
15/07/2022 23:07 21.984 api-ms-win-core-console-l1-1-0.dll
15/07/2022 23:07 22.008 api-ms-win-core-console-l1-2-0.dll
15/07/2022 23:07 22.008 api-ms-win-core-datetime-l1-1-0.dll
15/07/2022 23:07 21.984 api-ms-win-core-debug-l1-1-0.dll
15/07/2022 23:07 21.976 api-ms-win-core-errorhandling-l1-1-0.dll
15/07/2022 23:07 21.984 api-ms-win-core-fibers-l1-1-0.dll
15/07/2022 23:07 26.080 api-ms-win-core-file-l1-1-0.dll
15/07/2022 23:07 21.976 api-ms-win-core-file-l1-2-0.dll
15/07/2022 23:07 22.008 api-ms-win-core-file-l2-1-0.dll
15/07/2022 23:07 21.976 api-ms-win-core-handle-l1-1-0.dll
15/07/2022 23:07 21.984 api-ms-win-core-heap-l1-1-0.dll
15/07/2022 23:07 21.984 api-ms-win-core-interlocked-l1-1-0.dll
15/07/2022 23:07 21.976 api-ms-win-core-libraryloader-l1-1-0.dll
15/07/2022 23:07 21.976 api-ms-win-core-localization-l1-2-0.dll
15/07/2022 23:07 22.008 api-ms-win-core-memory-l1-1-0.dll
15/07/2022 23:07 22.008 api-ms-win-core-namedpipe-l1-1-0.dll
15/07/2022 23:07 21.992 api-ms-win-core-processenvironment-l1-1-0.dll
15/07/2022 23:07 21.984 api-ms-win-core-processthreads-l1-1-0.dll
15/07/2022 23:07 22.008 api-ms-win-core-processthreads-l1-1-1.dll
15/07/2022 23:07 21.976 api-ms-win-core-profile-l1-1-0.dll
15/07/2022 23:07 22.008 api-ms-win-core-rtlsupport-l1-1-0.dll
15/07/2022 23:07 21.976 api-ms-win-core-string-l1-1-0.dll
15/07/2022 23:07 21.976 api-ms-win-core-synch-l1-1-0.dll
15/07/2022 23:07 21.976 api-ms-win-core-synch-l1-2-0.dll
15/07/2022 23:07 22.008 api-ms-win-core-sysinfo-l1-1-0.dll
15/07/2022 23:07 21.984 api-ms-win-core-timezone-l1-1-0.dll
15/07/2022 23:07 22.008 api-ms-win-core-util-l1-1-0.dll
15/07/2022 23:07 22.008 api-ms-win-crt-conio-l1-1-0.dll
15/07/2022 23:07 26.080 api-ms-win-crt-convert-l1-1-0.dll
15/07/2022 23:07 22.008 api-ms-win-crt-environment-l1-1-0.dll
15/07/2022 23:07 21.976 api-ms-win-crt-filesystem-l1-1-0.dll
15/07/2022 23:07 21.976 api-ms-win-crt-heap-l1-1-0.dll
15/07/2022 23:07 22.000 api-ms-win-crt-locale-l1-1-0.dll
15/07/2022 23:07 30.200 api-ms-win-crt-math-l1-1-0.dll
15/07/2022 23:07 30.200 api-ms-win-crt-multibyte-l1-1-0.dll
15/07/2022 23:07 75.232 api-ms-win-crt-private-l1-1-0.dll
15/07/2022 23:07 21.984 api-ms-win-crt-process-l1-1-0.dll
15/07/2022 23:07 26.072 api-ms-win-crt-runtime-l1-1-0.dll
15/07/2022 23:07 26.072 api-ms-win-crt-stdio-l1-1-0.dll
15/07/2022 23:07 26.104 api-ms-win-crt-string-l1-1-0.dll
15/07/2022 23:07 21.984 api-ms-win-crt-time-l1-1-0.dll
15/07/2022 23:07 22.008 api-ms-win-crt-utility-l1-1-0.dll
30/01/2023 22:46 4.407.208 aria_chk.exe
30/01/2023 22:46 3.985.320 aria_dump_log.exe
30/01/2023 22:46 4.221.864 aria_ftdump.exe
30/01/2023 22:46 4.264.360 aria_pack.exe
30/01/2023 22:46 4.386.728 aria_read_log.exe
24/01/2023 15:37 327.504 concrt140.dll
30/01/2023 22:46 3.492.776 innochecksum.exe
30/01/2023 22:46 15.614.376 mariabackup.exe
30/01/2023 22:46 3.424.168 mbstream.exe
24/01/2023 15:37 579.920 msvcp140.dll
24/01/2023 15:37 35.664 msvcp140_1.dll
24/01/2023 15:37 197.456 msvcp140_2.dll
24/01/2023 15:37 50.000 msvcp140_atomic_wait.dll
24/01/2023 15:37 31.568 msvcp140_codecvt_ids.dll
22/10/2023 17:09 5.776 my.ini
30/01/2023 22:46 3.735.976 myisamchk.exe
30/01/2023 22:46 3.617.192 myisamlog.exe
30/01/2023 22:46 3.635.624 myisampack.exe
30/01/2023 22:46 3.600.808 myisam_ftdump.exe
30/01/2023 22:36 25.746 myrocks_hotbackup
30/01/2023 22:45 3.780.520 mysql.exe
30/01/2023 22:45 3.684.776 mysqladmin.exe
30/01/2023 22:45 3.818.408 mysqlbinlog.exe
30/01/2023 22:45 3.696.040 mysqlcheck.exe
30/01/2023 22:46 16.549.288 mysqld.exe
30/01/2023 22:45 3.770.280 mysqldump.exe
30/01/2023 22:36 8.478 mysqldumpslow.pl
30/01/2023 22:36 28.628 mysqld_multi.pl
30/01/2023 22:36 36.124 mysqlhotcopy.pl
30/01/2023 22:45 3.668.904 mysqlimport.exe
30/01/2023 22:45 3.668.904 mysqlshow.exe
30/01/2023 22:45 3.685.800 mysqlslap.exe
30/01/2023 22:36 8.878 mysql_config.pl
30/01/2023 22:36 4.384 mysql_convert_table_format.pl
30/01/2023 22:46 5.572.008 mysql_install_db.exe
30/01/2023 22:46 3.322.792 mysql_ldb.exe
30/01/2023 22:45 3.411.368 mysql_plugin.exe
30/01/2023 22:46 3.424.168 mysql_tzinfo_to_sql.exe
30/01/2023 22:45 3.519.400 mysql_upgrade.exe
30/01/2023 22:46 3.404.200 mysql_upgrade_service.exe
30/01/2023 22:46 2.674.088 mysql_upgrade_wizard.exe
30/01/2023 22:46 3.417.000 my_print_defaults.exe
30/01/2023 22:46 3.540.904 perror.exe
30/01/2023 22:46 3.393.448 replace.exe
30/01/2023 22:46 1.464.744 sst_dump.exe
15/07/2022 23:07 1.123.832 ucrtbase.dll
24/01/2023 15:37 109.392 vcruntime140.dll
30/05/2022 17:57 44.320 vcruntime140_1.dll
90 File(s) 145.484.830 bytes
2 Dir(s) 324.975.943.680 bytes free

C:\xampp\mysql\bin>dir/w
Volume in drive C is OS
Volume Serial Number is E2D9-DA9E

Directory of C:\xampp\mysql\bin

[.] [..]
api-ms-win-core-console-l1-1-0.dll
api-ms-win-core-console-l1-2-0.dll api-ms-win-core-datetime-l1-1-0.dll
api-ms-win-core-debug-l1-1-0.dll
api-ms-win-core-errorhandling-l1-1-0.dll api-ms-win-core-fibers-l1-1-0.dll
api-ms-win-core-file-l1-1-0.dll
api-ms-win-core-file-l1-2-0.dll api-ms-win-core-file-l2-1-0.dll
api-ms-win-core-handle-l1-1-0.dll
api-ms-win-core-heap-l1-1-0.dll api-ms-win-core-interlocked-l1-1-
0.dll api-ms-win-core-libraryloader-l1-1-0.dll
api-ms-win-core-localization-l1-2-0.dll api-ms-win-core-memory-l1-1-0.dll
api-ms-win-core-namedpipe-l1-1-0.dll
api-ms-win-core-processenvironment-l1-1-0.dll api-ms-win-core-processthreads-l1-
1-0.dll api-ms-win-core-processthreads-l1-1-1.dll
api-ms-win-core-profile-l1-1-0.dll api-ms-win-core-rtlsupport-l1-1-
0.dll api-ms-win-core-string-l1-1-0.dll
api-ms-win-core-synch-l1-1-0.dll api-ms-win-core-synch-l1-2-0.dll
api-ms-win-core-sysinfo-l1-1-0.dll
api-ms-win-core-timezone-l1-1-0.dll api-ms-win-core-util-l1-1-0.dll
api-ms-win-crt-conio-l1-1-0.dll
api-ms-win-crt-convert-l1-1-0.dll api-ms-win-crt-environment-l1-1-
0.dll api-ms-win-crt-filesystem-l1-1-0.dll
api-ms-win-crt-heap-l1-1-0.dll api-ms-win-crt-locale-l1-1-0.dll
api-ms-win-crt-math-l1-1-0.dll
api-ms-win-crt-multibyte-l1-1-0.dll api-ms-win-crt-private-l1-1-0.dll
api-ms-win-crt-process-l1-1-0.dll
api-ms-win-crt-runtime-l1-1-0.dll api-ms-win-crt-stdio-l1-1-0.dll
api-ms-win-crt-string-l1-1-0.dll
api-ms-win-crt-time-l1-1-0.dll api-ms-win-crt-utility-l1-1-0.dll
aria_chk.exe
aria_dump_log.exe aria_ftdump.exe
aria_pack.exe
aria_read_log.exe concrt140.dll
innochecksum.exe
mariabackup.exe mbstream.exe
msvcp140.dll
msvcp140_1.dll msvcp140_2.dll
msvcp140_atomic_wait.dll
msvcp140_codecvt_ids.dll my.ini
myisamchk.exe
myisamlog.exe myisampack.exe
myisam_ftdump.exe
myrocks_hotbackup mysql.exe
mysqladmin.exe
mysqlbinlog.exe mysqlcheck.exe
mysqld.exe
mysqldump.exe mysqldumpslow.pl
mysqld_multi.pl
mysqlhotcopy.pl mysqlimport.exe
mysqlshow.exe
mysqlslap.exe mysql_config.pl
mysql_convert_table_format.pl
mysql_install_db.exe mysql_ldb.exe
mysql_plugin.exe
mysql_tzinfo_to_sql.exe mysql_upgrade.exe
mysql_upgrade_service.exe
mysql_upgrade_wizard.exe my_print_defaults.exe
perror.exe
replace.exe sst_dump.exe
ucrtbase.dll
vcruntime140.dll vcruntime140_1.dll
90 File(s) 145.484.830 bytes
2 Dir(s) 324.975.943.680 bytes free

C:\xampp\mysql\bin>show databases;
'show' is not recognized as an internal or external command,
operable program or batch file.

C:\xampp\mysql\bin>mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9
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 |
| performance_schema |
| phpdasar |
| phpmyadmin |
| test |
+--------------------+
6 rows in set (0.001 sec)

MariaDB [(none)]> use test


Database changed
MariaDB [test]> show tables;
Empty set (0.001 sec)

MariaDB [test]> use phpdasar


Database changed
MariaDB [phpdasar]> show tables;
+--------------------+
| Tables_in_phpdasar |
+--------------------+
| siswa |
| tabel_minum_kopi |
+--------------------+
2 rows in set (0.001 sec)

MariaDB [phpdasar]> create table Daftar_Teman_Favorit_Saya (


-> id int auto_increment primary key,
-> Nama Varchar(50),
-> Status Varchar(50),
-> NIS/NIK Varchar(10),
-> Alasan Varchar(50),
-> Email Varchar(50)
-> );
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 '/NIK
Varchar(10),
Alasan Varchar(50),
Email Varchar(50)
)' at line 5
MariaDB [phpdasar]> create table Daftar_Teman_Favorit_Saya (
-> id int auto_increment primary key,
-> Nama varchar(50),
-> Status varchar(50),
-> NIS_NIK varchar(10),
-> Alasan_Dan_Kenapa? varchar(50),
-> E-mail varchar(50)
-> );
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(50),
E-mail varchar(50)
)' at line 6
MariaDB [phpdasar]> create table Daftar_Teman_Favorit_Saya
-> (
-> ID int auto_increment primary key,
-> Nama varchar(50),
-> Status varchar(50),
-> NIS_NIK varchar(50),
->
-> Alasan varchar(50),
-> Email varchar(50),
-> );
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 10
MariaDB [phpdasar]> CREATE TABLE Daftar_Teman_Favorit_Saya (
-> ID INT AUTO_INCREMENT PRIMARY KEY,
-> Nama VARCHAR(50),
-> Status VARCHAR(50),
-> NIS_NIK VARCHAR(50),
-> Alasan VARCHAR(50),
-> Email VARCHAR(50)
-> );
Query OK, 0 rows affected (0.007 sec)

MariaDB [phpdasar]> show tables;


+---------------------------+
| Tables_in_phpdasar |
+---------------------------+
| daftar_teman_favorit_saya |
| siswa |
| tabel_minum_kopi |
+---------------------------+
3 rows in set (0.001 sec)

MariaDB [phpdasar]> select * from daftar_teman_favorit_saya;


Empty set (0.001 sec)

MariaDB [phpdasar]> SHOW COLUMNS FROM Daftar_Teman_Favorit_Saya;


+---------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+----------------+
| ID | int(11) | NO | PRI | NULL | auto_increment |
| Nama | varchar(50) | YES | | NULL | |
| Status | varchar(50) | YES | | NULL | |
| NIS_NIK | varchar(50) | YES | | NULL | |
| Alasan | varchar(50) | YES | | NULL | |
| Email | varchar(50) | YES | | NULL | |
+---------+-------------+------+-----+---------+----------------+
6 rows in set (0.004 sec)

MariaDB [phpdasar]> describe daftar_teman_favorit_saya;


+---------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+----------------+
| ID | int(11) | NO | PRI | NULL | auto_increment |
| Nama | varchar(50) | YES | | NULL | |
| Status | varchar(50) | YES | | NULL | |
| NIS_NIK | varchar(50) | YES | | NULL | |
| Alasan | varchar(50) | YES | | NULL | |
| Email | varchar(50) | YES | | NULL | |
+---------+-------------+------+-----+---------+----------------+
6 rows in set (0.005 sec)

MariaDB [phpdasar]> insert into daftar_teman_favorit_saya (ID, Nama, Status,


NIS_NIK, Alasan, Email)
-> values ('','Hamano
Asuka','Pelajar_SMA','9913013000','Ramah_Dan_Jepang','hamanoasuka@gmail.com'),
->
('','KotaChin','Pelajar_SMA','1010129200','Ramah_Dan_Sinting','saltbutter@gmail.com
'),
-> ('','Muhammad Wazierudin
Akbar','Freelancer','7737722100','Mentor_Yang_Baik','wazierudinakbar@gmail.com'),
->
('','Tsahiya','Pelajar_SMP','0202933300','Pendengar_Yang_Baik','Tsahiya@gmail.com')
,
-> ('','Rafi','Pelajar_SMK','9821391800','Kangen','rafi??@gmail.com');
Query OK, 5 rows affected, 5 warnings (0.004 sec)
Records: 5 Duplicates: 0 Warnings: 5

MariaDB [phpdasar]> select * from daftar_teman_favorit_saya;


+----+---------------------------+-------------+------------+---------------------
+---------------------------+
| ID | Nama | Status | NIS_NIK | Alasan |
Email |
+----+---------------------------+-------------+------------+---------------------
+---------------------------+
| 1 | Hamano Asuka | Pelajar_SMA | 9913013000 | Ramah_Dan_Jepang |
hamanoasuka@gmail.com |
| 2 | KotaChin | Pelajar_SMA | 1010129200 | Ramah_Dan_Sinting |
saltbutter@gmail.com |
| 3 | Muhammad Wazierudin Akbar | Freelancer | 7737722100 | Mentor_Yang_Baik |
wazierudinakbar@gmail.com |
| 4 | Tsahiya | Pelajar_SMP | 0202933300 | Pendengar_Yang_Baik |
Tsahiya@gmail.com |
| 5 | Rafi | Pelajar_SMK | 9821391800 | Kangen |
rafi??@gmail.com |
+----+---------------------------+-------------+------------+---------------------
+---------------------------+
5 rows in set (0.000 sec)

MariaDB [phpdasar]> update daftar_teman_favorit_saya


-> set Nama = Rafi Femcrott
-> set Alasan = Kangen_Dan_Sefrekuensi
-> where ID = 5;
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
'Femcrott
set Alasan = Kangen_Dan_Sefrekuensi
where ID = 5' at line 2
MariaDB [phpdasar]> SELECT * FROM Daftar_Teman_Favorit_Saya WHERE ID = 5;
+----+------+-------------+------------+--------+------------------+
| ID | Nama | Status | NIS_NIK | Alasan | Email |
+----+------+-------------+------------+--------+------------------+
| 5 | Rafi | Pelajar_SMK | 9821391800 | Kangen | rafi??@gmail.com |
+----+------+-------------+------------+--------+------------------+
1 row in set (0.001 sec)

MariaDB [phpdasar]> update daftar_teman_favorit_saya


-> set nama = Rafii Femcrott, set Alasan = Kangen_Dan_Seideologi
-> where id = 5
-> ;
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
'Femcrott, set Alasan = Kangen_Dan_Seideologi
where id = 5' at line 2
MariaDB [phpdasar]> update daftar_teman_favorit_saya
-> -> set nama = Rafii Femcrott, set Alasan = Kangen_Dan_Seideologi
-> :
-> ;
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 '-> set
nama = Rafii Femcrott, set Alasan = Kangen_Dan_Seideologi
:' at line 2
MariaDB [phpdasar]> update daftar_teman_favorit_saya
-> set nama = Rafii Femcrott, set Alasan = Kangen_Dan_Seideologi
-> where ID = 5;
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
'Femcrott, set Alasan = Kangen_Dan_Seideologi
where ID = 5' at line 2
MariaDB [phpdasar]> UPDATE Daftar_Teman_Favorit_Saya
-> SET Nama = 'Rafi Femcrot', Alasan = 'Teman yang baik'
-> WHERE ID = 5;
Query OK, 1 row affected (0.003 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [phpdasar]> select * from Daftar_Teman_Favorit_Saya;


+----+---------------------------+-------------+------------+---------------------
+---------------------------+
| ID | Nama | Status | NIS_NIK | Alasan |
Email |
+----+---------------------------+-------------+------------+---------------------
+---------------------------+
| 1 | Hamano Asuka | Pelajar_SMA | 9913013000 | Ramah_Dan_Jepang |
hamanoasuka@gmail.com |
| 2 | KotaChin | Pelajar_SMA | 1010129200 | Ramah_Dan_Sinting |
saltbutter@gmail.com |
| 3 | Muhammad Wazierudin Akbar | Freelancer | 7737722100 | Mentor_Yang_Baik |
wazierudinakbar@gmail.com |
| 4 | Tsahiya | Pelajar_SMP | 0202933300 | Pendengar_Yang_Baik |
Tsahiya@gmail.com |
| 5 | Rafi Femcrot | Pelajar_SMK | 9821391800 | Teman yang baik |
rafi??@gmail.com |
+----+---------------------------+-------------+------------+---------------------
+---------------------------+
5 rows in set (0.000 sec)

MariaDB [phpdasar]> update Daftar_Teman_Favorit_Saya


-> set Alasan = Teman_Mengont**
-> where ID = 5;
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 '*
where ID = 5' at line 2
MariaDB [phpdasar]> update Daftar_Teman_Favorit_Saya
-> set Alasan = Teman_Mengont__
-> where ID = 5;
ERROR 1054 (42S22): Unknown column 'Teman_Mengont__' in 'field list'
MariaDB [phpdasar]> update Daftar_Teman_Favorit_Saya
-> SET Alasan = Teman_Mengont__
-> WHERE ID = 5;
ERROR 1054 (42S22): Unknown column 'Teman_Mengont__' in 'field list'
MariaDB [phpdasar]> update Daftar_Teman_Favorit_Saya
-> SET Alasan = Teman_Yang_Satu
-> WHERE ID = 5;
ERROR 1054 (42S22): Unknown column 'Teman_Yang_Satu' in 'field list'
MariaDB [phpdasar]> UPDATE Daftar_Teman_Favorit_Saya
-> SET Alasan = 'Teman_Yang_Satu'
-> WHERE ID = 5;
Query OK, 1 row affected (0.003 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [phpdasar]> select * from Daftar_Teman_Favorit_Saya;


+----+---------------------------+-------------+------------+---------------------
+---------------------------+
| ID | Nama | Status | NIS_NIK | Alasan |
Email |
+----+---------------------------+-------------+------------+---------------------
+---------------------------+
| 1 | Hamano Asuka | Pelajar_SMA | 9913013000 | Ramah_Dan_Jepang |
hamanoasuka@gmail.com |
| 2 | KotaChin | Pelajar_SMA | 1010129200 | Ramah_Dan_Sinting |
saltbutter@gmail.com |
| 3 | Muhammad Wazierudin Akbar | Freelancer | 7737722100 | Mentor_Yang_Baik |
wazierudinakbar@gmail.com |
| 4 | Tsahiya | Pelajar_SMP | 0202933300 | Pendengar_Yang_Baik |
Tsahiya@gmail.com |
| 5 | Rafi Femcrot | Pelajar_SMK | 9821391800 | Teman_Yang_Satu |
rafi??@gmail.com |
+----+---------------------------+-------------+------------+---------------------
+---------------------------+
5 rows in set (0.000 sec)

MariaDB [phpdasar]> show tables;


+---------------------------+
| Tables_in_phpdasar |
+---------------------------+
| daftar_teman_favorit_saya |
| siswa |
| tabel_minum_kopi |
+---------------------------+
3 rows in set (0.001 sec)
MariaDB [phpdasar]> drop table tabel_minum_kopi;
Query OK, 0 rows affected (0.011 sec)

MariaDB [phpdasar]> show tables;


+---------------------------+
| Tables_in_phpdasar |
+---------------------------+
| daftar_teman_favorit_saya |
| siswa |
+---------------------------+
2 rows in set (0.001 sec)

MariaDB [phpdasar]> ALTER TABLE Users


-> ADD Tanggal_Lahir DATE;
ERROR 1146 (42S02): Table 'phpdasar.users' doesn't exist
MariaDB [phpdasar]> Bye
Ctrl-C -- exit!

C:\xampp\mysql\bin>mysql -u root -p
Enter password:
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)]> use phpdasar


Database changed
MariaDB [phpdasar]> kkk 2edPKZ_}CZ
-> );
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 'kkk
2edPKZ_}CZ
)' at line 1
MariaDB [phpdasar]> ALTER TABLE daftar_teman_favorit_saya
-> ADD Tanggal_Lahir DATE;
Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [phpdasar]> select * daftar_teman_favorit_saya;


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
'daftar_teman_favorit_saya' at line 1
MariaDB [phpdasar]> select * from daftar_teman_favorit_saya;
+----+---------------------------+-------------+------------+---------------------
+---------------------------+---------------+
| ID | Nama | Status | NIS_NIK | Alasan |
Email | Tanggal_Lahir |
+----+---------------------------+-------------+------------+---------------------
+---------------------------+---------------+
| 1 | Hamano Asuka | Pelajar_SMA | 9913013000 | Ramah_Dan_Jepang |
hamanoasuka@gmail.com | NULL |
| 2 | KotaChin | Pelajar_SMA | 1010129200 | Ramah_Dan_Sinting |
saltbutter@gmail.com | NULL |
| 3 | Muhammad Wazierudin Akbar | Freelancer | 7737722100 | Mentor_Yang_Baik |
wazierudinakbar@gmail.com | NULL |
| 4 | Tsahiya | Pelajar_SMP | 0202933300 | Pendengar_Yang_Baik |
Tsahiya@gmail.com | NULL |
| 5 | Rafi Femcrot | Pelajar_SMK | 9821391800 | Teman_Yang_Satu |
rafi??@gmail.com | NULL |
+----+---------------------------+-------------+------------+---------------------
+---------------------------+---------------+
5 rows in set (0.000 sec)

MariaDB [phpdasar]> ALTER TABLE Users


-> DROP COLUMN Tanggal_Lahir;
ERROR 1146 (42S02): Table 'phpdasar.users' doesn't exist
MariaDB [phpdasar]> ALTER TABLE Users
-> DROP COLUMN Tanggal_Lahir;
ERROR 1146 (42S02): Table 'phpdasar.users' doesn't exist
MariaDB [phpdasar]> ALTER TABLE daftar_teman_favorit_saya
-> DROP COLUMN Tanggal_Lahir;
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [phpdasar]> ALTER TABLE Daftar_Teman_Favorit_Saya


-> CHANGE COLUMN Alasan Alasan_Baruu VARCHAR(50);
Query OK, 0 rows affected (0.005 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [phpdasar]> rename Daftar_Teman_Favorit_Saya to Teman_Favorit_Saya;


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
'Daftar_Teman_Favorit_Saya to Teman_Favorit_Saya' at line 1
MariaDB [phpdasar]> rename table Daftar_Teman_Favorit_Saya to Teman_Favorit_Saya;
Query OK, 0 rows affected (0.007 sec)

MariaDB [phpdasar]> Bye


Ctrl-C -- exit!

C:\xampp\mysql\bin>mysql -u root -p

You might also like