> If you just need to select a database, you can do it while connecting to
> mysql:
>
> mysql -u${DB_USER} -p${DB_PASSWORD} ${DATABASE} -e 'update foo set bar=0'
>
> Although the other suggestions, of using semicolons or scripts, work
> as well. If it's just a one-liner, though, the above will wo
Dustin Krysak wrote:
> Hi there, I was wondering if it was possible to issue multiple commands
> to mysql from a regular command line? For example i know you can issue
> a single by the following:
>
> mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases'
e.g.,
-e 'show databases; use
On Fri, 2005-10-21 at 14:34 -0700, Dustin Krysak wrote:
> Hi there, I was wondering if it was possible to issue multiple
> commands to mysql from a regular command line? For example i know you
> can issue a single by the following:
>
> mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases'
>
Hi there, I was wondering if it was possible to issue multiple
commands to mysql from a regular command line? For example i know you
can issue a single by the following:
mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases'
Now what if for example i needed to select a database, then run a
