MariaDB:Delete Database: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
*Memperlihatkan seluruh database yang tersedia | *Memperlihatkan seluruh database yang tersedia | ||
<syntaxhighlight lang="bash"> | |||
sudo mysql -u root | |||
</syntaxhighlight><syntaxhighlight lang="sql"> | |||
SHOW DATABASES; | |||
'''Output''' | </syntaxhighlight>'''Output''' | ||
mysql> SHOW DATABASES; | mysql> SHOW DATABASES; | ||
+--------------------+ | +--------------------+ | ||
| Line 17: | Line 17: | ||
*Menghapus database | *Menghapus database | ||
<syntaxhighlight lang="sql"> | |||
DROP DATABASE namedatabase; | |||
</syntaxhighlight> | |||
==Source== | ==Source== | ||
Latest revision as of 21:50, 20 November 2022
- Memperlihatkan seluruh database yang tersedia
sudo mysql -u root
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;