Hi, 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 --password=pass Have fun Bernd -- [Zufallssig 10] [Deng] on AO Forum: "Good judgement is the result of experience... experience often comes from bad judgement." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
