1

I am able to create databases and tables using the User Interface in phpMyAdmin , but when I do the same using MySQL commands , It does not work. I get this error :

SQL query:

DROP DATABASE 'alphacrm'

MySQL said: Documentation

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 ''alphacrm'' at line 1**

Improve this question

1 Answer 1

Reset to default
2

don't use quote 

DROP DATABASE alphacrm;

my sql object don't need quotes eventually use backtics for reversed word and compite named eg: 

 `my obj`
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thanks , it worked! May god bless you .. and apologies for asking such a silly question .. i am really new to this, tutorials did it using the quotes.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.