[FIXED] how can I delete a database from my phpmyadmin dashboard which named with multiple strings like "coming soon"?

Issue

how can I delete a database from my phpmyadmin dashboard which named with multiple strings like "coming soon"? I tried drop database coming soon but it's showing me this error.

drop database coming soon;

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'soon' at line 1

Solution

Backticks are used in MySQL to select columns and tables from your MySQL source. In the example below we are calling to the table titled Album and the column Title. Using backticks we are signifying that those are the column and table names. RESOURCE

SELECT `Album`.`Title`
FROM `Album` AS `Album`
GROUP BY `Album`.`Title`
ORDER BY `Title` ASC
LIMIT 10;

The thing that the article does NOT mention is the multiple stringed table or database names. The above statement would work with, or without, backticks. However this statement would not work without backticks:

SELECT `Album`.`Title One`, `Album`.`Title Two`

Answered By - Zak

Answer Checked By - Gilberto Lyons (PHPFixing Admin)