MariaDB:Delete Database: Difference between revisions
No edit summary |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
*Memperlihatkan seluruh database yang tersedia | *Memperlihatkan seluruh database yang tersedia | ||
<syntaxhighlight lang="bash"> | |||
sudo mysql -u root | |||
'''Output''' | </syntaxhighlight><syntaxhighlight lang="sql"> | ||
SHOW DATABASES; | |||
</syntaxhighlight>'''Output''' | |||
mysql> SHOW DATABASES; | mysql> SHOW DATABASES; | ||
+--------------------+ | +--------------------+ | ||
| Line 15: | Line 17: | ||
*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]] | |||
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;