One observation that is possible with the provided information is that
the SQL format for insert ends with the ) that closes the values
clause. You have some extra digits after that. Those should
consistently generate the listed error. I've never seen msql fail to
catch things like that but there may be some obscure bug that I haven't
seen.
On 25/09/2004, at 4:54 AM, yshjiang wrote:
> Dear David:
> When I imported a big text of to a database of msql ,there was an
> error "
>
> Query was: insert into xz values ( 1, 1, '66-152jl', 0, 0, 200, .00,
> .00, .00, .00, 6.00, 6.00, 4.00, .00, 1.00) .00, 0
> "SQL error at input line 1: syntax error at line 1 near "0
>
> But when I only imported the record, there wasn't any error. Why?
> please tell me!
> yours yeshangjiang
-----------------------------------------------------------------
This is the Mini SQL Mailing List operated by Hughes Technologies
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Fri Oct 01 2004 - 00:20:01 PDT