CODEWITHSUNDEEP
mysqlwindowscommand-line
nor0x
nor0x

Reputation: 1213

MySQL Commands not working on Windows CMD

I have a problem with my MySQL setup on Windows. First of all I downloaded the latest Windows Installer from dev.mysql.com and installed the server. Now when I am trying to execute MySQL commands in the cmd (I already modified the PATH variable, and I am logged in as MySQL root user) the command won't be executed, there is just a "->" showing up.

I can only exit this "mode" by typing in "\q", and not by executing "exit".

Maybe you can help me, I really need MySQL for my Ruby on Rails project.

Thank you!

Upvotes: 1

Views: 2537

Answers (1)

Patrick Evans
Patrick Evans

Reputation: 42736

The MySQL command line lets you use multiple lines for a command, for instance

mysql> SELECT *
> FROM myTable
> LIMIT 0,10;

The use of the semicolon ; is to tell the command line that that is the end of the command

So after your commands on the command line end it with a semicolon if you do not need to add anything else

Upvotes: 6

Related Questions