I am new to MySQL. I am using SQLYOG for database manipulations. I have a doubt regarding creation of database. When I tried to create a database “a b c” through the following query " create database ‘a b c’ " , I got an error message. But by clicking on the ‘DB’ menu in the menubar and selecting ‘create database’ menuitem, I am able to create the database ‘a b c’.
Kindly let me know How can I create the database through query if the database name has blank spaces in it?