Giuseppe Maxia wrote:
> 12/11/2001 05:32:28, "PI Xu" <[EMAIL PROTECTED]> wrote:
>
> >Hi, Buddies:
> >
> >I used perl to run sql commands from a Text file, it always can't finish
> >totally and report error in unstable lines .
> >The error report that sql syntax error, but the syntax is same, just same,
> >and many sql lines;
> >Would you please tell me what this happen and how to resolve it?
> >
> >Thanks in Advance!
> >Bill
> >
> >PERL COMMANDS: system('mysql -uusername -ppassword database <
> >pricfile.sql');
> >
> >if pricfile.sql has 37871 lines sql commands like
> >update products set retail=43.00 where partno='123456';
> >then the perl program give
> > ERROR 1064 at line 37850: You have an error in your SQL syntax near
> >''99922' at line 1
> >
>
> I think you should have a look at the lines 37849 and 37850.
> The error could be that the previous one was wrongly terminated,
> or the current one has an invalid value.
> It could be a problem of unproper quoting.
> Having a look at the lines involved could be helpful. How did you produce the file?
>
> Bye
> Giuseppe
>
> >
> >if pricfile.sql has 19999 lines, then the perl program give
> >ERROR 1064 at line 19932: You have an error in your SQL syntax near '' at
> >line 1
> >
> >if pricfile.sql has 17872 lines sql commands like, then the perl program
> >give
> >ERROR 1064 at line 17848: You have an error in your SQL syntax near '' at
> >line
> >
> >
> >---------------------------------------------------------------------
> >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
> >
> >
> >
>
> ---------------------------------------------------------------------
> 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
One potential error is the lack of quoting in: retail=43.00 where...
Try using: retail='43.00' where...
Also, it would make things easier if you would give the exact error message, with the
line where the error occurred.
Denis
---------------------------------------------------------------------
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
