How to drop NAMMIK with backquote ? It was accidentially added by CALL sys.create_synonym_db;
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| `NAMMIK` |
| NAMMIK |
| mysql |
| nammik |
| performance_schema |
| sys |
+--------------------+
mysql> DROP DATABSE `NAMMIK`;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABSE `NAMMIK`' at line 1
>Solution :
Try with:
DROP DATABASE `` `NAMMIK` ``;