Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

How can I create the database through query if the database name has blank spaces in it [message #1962] Sat, 29 September 2007 01:16  kalyan_askc Messages: 3 Registered: September 2007 Location: India Junior Member Hi All, 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? Regards, A.S.Kalyan. A.S.Kalyan Report message to a moderator

	How can I create the database through query if the database name has blank spaces in it By: kalyan_askc on Sat, 29 September 2007 01:16
	Re: How can I create the database through query if the database name has blank spaces in it By: mikec on Sun, 30 September 2007 18:25
	Re: How can I create the database through query if the database name has blank spaces in it By: kalyan_askc on Mon, 01 October 2007 00:26
	Re: How can I create the database through query if the database name has blank spaces in it By: sterin on Sun, 30 September 2007 20:05
	Re: How can I create the database through query if the database name has blank spaces in it By: kalyan_askc on Mon, 01 October 2007 00:29
	Re: How can I create the database through query if the database name has blank spaces in it By: mikec on Mon, 01 October 2007 00:44

Previous Topic:	prepared statements in MySQL
Next Topic:	MYSQL Swapping Issue / Memory Usage

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]