Nik Vogiatzis writes:
> hi all...
>
> recently... i created an .sql file that was meant to create a schema...
> as would be done with oracle...
>
> but every time i have attempted run the file, it keeps on complaining
> after the first ; saying that there is an error near the semi-colon...
> yet, when i run each create table statement individually, no probs...
> the tables are created...
>
> can MySQL handle multiple SQL statements from within a .sql file? am i
> doing something wrong?
>
> cheers
> nik
>
>
HI!
Mysql has no problem what so ever with multiple statements.
So, please send me at least part of .sql file to try it myself.
BTW what version of MySQL are you using and on what OS ??
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped|
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
