i'm trying to do some practices on command line..
as you see in the pic the command is not triggering. i'm pressing Enter. (as described in practicing book)
3 Answers
End a command with a semicolon ;
CREATE DATABASE deneme;
As long as it keeps printing the -> prompt on new lines, it is expecting the ; terminator.
answered May 19, 2011 at 1:39
Michael Berkowski
271k47 gold badges450 silver badges395 bronze badges
2 Comments
ceylan
thank you. i got it now. so in this pic mysql is waiting for more commands until ; right?
ceylan
@micheal, i am trying to connect but getting this error: mysql> -uroot; 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 '-uroo t' at line 1 mysql>
Use ; as stated.
This is a good example of why it is good practice to always end your SQL statements with a semicolon. It's a good habit to get into.
3 Comments
Michael Berkowski
+1 many clients don't require the
; but it is an excellent habit.ceylan
i am trying to connect but getting this error: mysql> -uroot; 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 '-uroo t' at line 1 mysql> –
dtbarne
Are you trying to connect to the mysql client while you're already in it?
just type
;
at the end of the line :-)
