> 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 work. > > -Sheeri > > On 10/21/05, Dustin Krysak <[EMAIL PROTECTED]> 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' > > > > Now what if for example i needed to select a database, then run an > > update against it? With a single command it exits back out to a > > shell, so there is no chance to issue a 2nd command. > > > > Thanks in advance! > > > > Dustin > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]