Making a mysql databse in ssh
Okay so i used the command:
create database test; and i get this error: 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 test create database test' at line 1 I have mysql installed, i am logged in. latest mysql. Edit: Sorry if this is in the wrong place, i am new. |
Hi, welcome to LQ!
Now I'm not an expert on MySQL by any stretch of the imagination, but did you try that w/o the semicolon? Cheers, Tink |
Hi,
From what i see, it appears that you press del/backspace or something like that at the mysql command line, the message is clear, the mysql client log your query as: 'databse test create database test' Best regards, |
Quote:
But it turns out the database was already created, hence why i was getting this error, thanks though. |
Quote:
to do with language semantics? Never mind... Cheers, Tink |
All times are GMT -5. The time now is 07:11 PM. |