learner
learner

Reputation: 2789

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

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

Upvotes: 9

Views: 35341

Answers (5)

Try this on Windows:

  • Open window console Run CMD
  • type/copy: mysql -h hostname -u UserName -pPassWordTogether dbNAme -e"select * from table;" > D:/file.csv
  • Easy and fast.

Good Luck.

Upvotes: 0

Ravindra Kumar
Ravindra Kumar

Reputation: 1940

Yes, We can access whole DB from command line.  
1. Connect to DB (no space between -p and password)
    mysql -h <host> -u <username> -p<password>
2. Now we can check how many db we have
   show databases;
or many more commands and even we can execute quires through command line. For more command details http://g2pc1.bu.edu/~qzpeng/manual/MySQL%20Commands.htm

Upvotes: 1

zzapper
zzapper

Reputation: 5043

practical example of @devarts recommendation enter your user & password & Database

mysql -uUSER -pPASSWORD  -e 'SHOW DATABASES;' -- list databases

mysql -uUSER -pPASSWORD  MyDATABASE -e 'SHOW TABLES;' -- list tables in MyDATABASE

Upvotes: 3

Devart
Devart

Reputation: 121902

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

Upvotes: 13

Jaydee
Jaydee

Reputation: 4158

You can install the MySQL client for windows and then use that for sending commands to a server.

http://dev.mysql.com/doc/refman/5.0/en/mysql.html

You can use the following type of format for commands

mysql db_name < script.sql > output.tab

or

shell> mysql --user=user_name --password=your_password db_name

Then type an SQL statement, end it with “;”, \g, or \G and press Enter.

Upvotes: 4

Related Questions