MariaDB:Delete Database: Difference between revisions
Created page with "*Memperlihatkan seluruh database yang tersedia SHOW DATABASES; *Menghapus database DROP DATABASE namedatabase; ==Source== *[https://bit.ly/3Fwg4Sv gridscale.io] Categor..." |
No edit summary |
||
| Line 1: | Line 1: | ||
*Memperlihatkan seluruh database yang tersedia | *Memperlihatkan seluruh database yang tersedia | ||
SHOW DATABASES; | SHOW DATABASES; | ||
'''Output''' | |||
mysql> SHOW DATABASES; | |||
+--------------------+ | |||
| Database | | |||
+--------------------+ | |||
| information_schema | | |||
| blog | | |||
| mysql | | |||
| performance_schema | | |||
+--------------------+ | |||
4 rows in set (0.00 sec) | |||
*Menghapus database | *Menghapus database | ||
Revision as of 08:10, 15 November 2021
- Memperlihatkan seluruh database yang tersedia
SHOW DATABASES;
Output
mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | blog | | mysql | | performance_schema | +--------------------+ 4 rows in set (0.00 sec)
- Menghapus database
DROP DATABASE namedatabase;