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

ismetguzelgun · Accepted Answer · 2020-06-13 17:34:40Z

1

You can use DROP DATABASE dbname syntax.

answered Jun 13, 2020 at 17:34

ismetguzelgun

1,1058 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

yes i know but how can i do it when i dont know the name?

You mean what? Dynamically dropping or without knowing anything ? If you mean second that is not possible. You have to indicate dbname.

Nikola Novak · Accepted Answer · 2021-10-25 13:52:59Z

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, 2021 at 13:52

Nikola Novak

4,5206 gold badges28 silver badges36 bronze badges

shim-kun · Accepted Answer · 2020-06-13 17:31:33Z

0

This is the syntax:

DROP DATABASE databasename;

answered Jun 13, 2020 at 17:31

shim-kun

1232 silver badges10 bronze badges

yes i know but how can i do it when i dont know the name?