![]() |
Unknown database error
Hi,
I have used the following code to get xml output from mysql. Code:
>mysql -u root -X -e "select * from xxx" database_name;Code:
ERROR:1049<42000>:unknown database 'database_name;' |
Re: Unknown database error
As far as the syntax is concerned, it is correct. But the above error occurs only when the database that you are trying to use "database_name" doesn't exist.
You should check whether you have specified the correct database name and then try the command again. |
Re: Unknown database error
Hi venami,
Thanks for the reply.I got it solved by removing semicolon at the end of the statement. Thanks. |
Re: Unknown database error
Very good :) I still remember me doing the same mistake a long time ago :D
I missed to notice it in your error statement :) |
| All times are GMT +5.5. The time now is 09:50. |