how can i delete the database that i am in it in mysql? without knowing the name of the database DROP DATABASE()

Question

how can i delete the current database?

DROP DATABASE()

ERROR 1064 (42000): You have an error in your SQL syntax

this is the error that i get

similar question https://stackoverflow.com/questions/21751868/delete-a-database-in-phpmyadmin — turivishal, Jun 13 '20 at 18:01

score 1 · Answer 1 · answered Jun 13 '20 at 17:34

1

You can use DROP DATABASE dbname syntax.

answered Jun 13 '20 at 17:34

ismetguzelgun

yes i know but how can i do it when i dont know the name? – eyal Jun 13 '20 at 18:26
You mean what? Dynamically dropping or without knowing anything ? If you mean second that is not possible. You have to indicate dbname. – ismetguzelgun Jun 13 '20 at 18:29

score 1 · Answer 2 · answered Oct 25 '21 at 13:52

1

SET @q = CONCAT('DROP DATABASE ', DATABASE(), ';');
PREPARE stmt FROM @q;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

All precautions that apply to any statement involving a DROP, and especially a DROP DATABASE, apply here too, and then some.

answered Oct 25 '21 at 13:52

Nikola Novak

score 0 · Answer 3 · answered Jun 13 '20 at 17:31

0

This is the syntax:

DROP DATABASE databasename;

answered Jun 13 '20 at 17:31

shim-kun

yes i know but how can i do it when i dont know the name? – eyal Jun 13 '20 at 18:26

3 Answers3