Scott Haneda wrote:
> 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 ----------------------------- hassan@stripped
Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
dream. code.
