Split MySQL query into an [executional part] and a [MySQL command part]

Question

Following

mysql -u root -ppassword -D database -s -N -e "SELECT id FROM myTable"

with special password and database is working fine.

I want to split the code into two parts:

and

to execute it with something similar like:

mysqlE query

How can I do this?

passing a password on the command line is a bad idea as it can easily be viewed from /proc or by running ps. See unix.stackexchange.com/a/205184/7696 for a better alternative. Remember to chmod 600 the config file. — cas, Oct 21 '15 at 0:02

Lambert · Accepted Answer · 2015-10-20 21:01:08Z

up vote 1 down vote accepted

You almost have it already for a shell script:

#!/bin/bash

mysqlE="mysql -u root -ppassword -D database -s -N -e"
query="SELECT id FROM myTable"
$mysqlE "$query"

Another way is to put the mysql command in a function (put it in ~/.bashrc for instance)

function mysqlE()
{
    mysql -u root -ppassword -D database -s -N -e "$@"
}

from a new shell or source ~/.bashrc use

mysqlE "$query"

answered Oct 20 '15 at 21:01

Lambert

5,444116

It's working fine. Thank you very much! – Peter Leger Oct 20 '15 at 21:20

add a comment |

1 Answer 1