2 messages in com.mysql.lists.mysqlRe: Scripts| From | Sent On | Attachments |
|---|---|---|
| Manuel Dugué | 05 Jun 2001 03:24 | |
| Dibo Chen | 05 Jun 2001 07:17 |
| Subject: | Re: Scripts |
|---|---|
| From: | Dibo Chen (di...@rjka.com) |
| Date: | 06/05/2001 07:17:54 AM |
| List: | com.mysql.lists.mysql |
Manuel Dugué wrote:
Hi, I created some Scripts of the Type *.sql. In these Scripts there are pure SQL Statements, seperated by a ';'. How can I execute those Scripts (automated) in mySQL?
mysql -u ... -p.. -h ... < scr1.sql etc.
Is there a possibility to make one Script, that starts other scripts... Can anybody help me?
put them in a shell script, say run.csh (or sh or bash or ksh ...): mysql -u ... -p.. -h ... < scr1.sql ..... mysql -u ... -p.. -h ... < scr100.sql
then just run run.csh
thanx Manuel
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-dibo=rjka...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php