That's a good question and I need some help related to the same too.
Usually I create scripts like:
createSequences.sql,
createTableX.sql,
createTableY.sql,
populateTableX,etc..
that are called by a script called makeDB.sql
The way I run it in Oracle is:
sqL> @makeDB
How can I do the same with mySQL???
What is the sintax for calling a script like these?
Thanks
siomara
>From: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: some question about create db
>Date: Fri, 4 May 2001 17:34:59 +0200
>
>I have to create a database from an application (written in perl)
>how can I do?
>how can I create a db if the user is not a root?
>which command can I use?
>Thank you in advance, Mario.
>
>---------------------------------------------------------------------
>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 <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php