Can we run a mysql query through command prompt in windows?

mysql command-line mysql5
learner picture learner · Sep 16, 2011 · Viewed 30.1k times · Source

Can we run MySQL query from windows command prompt? If so, how can we do that and process the query result through command prompt?

Answer

Devart picture Devart · Sep 16, 2011

Try to use mysql — the MySQL command-line tool with '--execute=statement' or '-e statement' option.

Related questions

How to get a list of user accounts using the command line in MySQL?

I'm using the MySQL command line utility and can navigate through a database. Now I need to see a list of user accounts. How can I do this? I'm using MySQL version 5.4.1.

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How to run SQL script in MySQL?

I want to execute a text file containing SQL queries, in MySQL. I tried to run source /Desktop/test.sql and received the error: mysql> . \home\sivakumar\Desktop\test.sql ERROR: Failed to open file '\home\sivakumar\Desktop\…

Read More