Am Mittwoch, 4. Februar 2004 07:19 schrieb Hassan Schroeder:
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?
2 possible ways to go:
Feed a Textfile with your statement in the db:
PATH/mysql db < /sql_scripts/sql_statements_as_textfile --password=pass
Give command directly In the shell-script:
PATH/mysql --skip-column-names -e "SELECT table SET blabla" db
[Deng] on AO Forum: "Good judgement is the result of experience...
experience often comes from bad judgement."