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 |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
*Memperlihatkan seluruh database yang tersedia | *Memperlihatkan seluruh database yang tersedia | ||
SHOW DATABASES; | <syntaxhighlight lang="bash"> | ||
sudo mysql -u root | |||
</syntaxhighlight><syntaxhighlight lang="sql"> | |||
SHOW DATABASES; | |||
</syntaxhighlight>'''Output''' | |||
mysql> SHOW DATABASES; | |||
+--------------------+ | |||
| Database | | |||
+--------------------+ | |||
| information_schema | | |||
| blog | | |||
| mysql | | |||
| performance_schema | | |||
+--------------------+ | |||
4 rows in set (0.00 sec) | |||
*Menghapus database | *Menghapus database | ||
<syntaxhighlight lang="sql"> | |||
DROP DATABASE namedatabase; | |||
</syntaxhighlight> | |||
==Source== | ==Source== | ||
*[https:// | *[https://gridscale.io/en/community/tutorials/mysql-datenbank-erstellen-loeschen/ gridscale.io] | ||
[[Category:Server]] | [[Category:Server]] | ||
[[Category:Database]] | |||