How do you run a single query through mysql from the command line

Question

I m looking to be able to run a single query on a remote server in a scripted task   For example  intuitively  I would imagine it would go something like   mysql -uroot -p -hslavedb mydomain com mydb production  select   from users

User · Answer

echo  select   from users     mysql -uroot -p -hslavedb mydomain com mydb production

User · Answer

From the mysql man page     You can execute SQL statements in a script file  batch file  like this          shell gt  mysql db name  lt  script sql  gt  output tab  Put the query in script sql and run it

User · Answer

mysql -u  lt user gt  -p -e  select   from schema table

User · Answer

here s how you can do it with a cool shell trick   mysql -uroot -p -hslavedb mydomain com mydb production  lt  lt  lt   select   from users      lt  lt  lt   instructs the shell to take whatever follows it as stdin  similar to piping from echo   use the -t flag to enable table-format output

User · Answer

mysql -uroot -p -hslavedb mydomain com mydb production -e  select   from users     From the usage printout      -e  --execute name   Execute command and quit   Disables --force and history file

User · Answer

If it s a query you run often  you can store it in a file  Then any time you want to run it   mysql  lt  thefile    with all the login and database flags of course

[sql] How do you run a single query through mysql from the command line?

Examples related to sql

Examples related to mysql

Examples related to unix

Examples related to command-line