I need to to the following Select serial from serials;
Problem is I need to run this from a script which cron will call once a day, how do you pass a select statement to mysql with user and pass so it can all happen in one go?
Something like this should work:
#!/bin/bash
/path/to/msyql -umack -ptheknife -e "use serialDB; select serial from serials;"
Not tested with cron, but ...
HTH, -- Hassan Schroeder ----------------------------- [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
dream. code.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
