INSERT INTO (comment_lines)
VALUES('020750000030009219','09','20','35','N','','00003','');
maybe even that
>===== Original Message From daniel <[EMAIL PROTECTED]> =====
>INSERT INTO comment_lines VALUES('020750000030009219','09','20','35','N','
>','00003','');
>
>try that u didnt seem to have quortation around the 00003
>>===== Original Message From Freedom Advocate <[EMAIL PROTECTED]> =====
>>This is the command I am having problems with and the error that I am
>getting.
>>What follows is some things I did to troubleshoot this problem. I can't see
>>any problems with the SQL and as I note below, the line works fine when I
>>apply it to the DB after getting the error. Help!
>>
>>[root@Casey root]# mysql -u root -p < po_file
>>Enter password:
>>ERROR 1064 at line 950282: You have an error in your SQL syntax near
>>'020750000030009219','09','20','35','N',' ',00013,'
>> ',000000.9500,000000.6318,'' at line 1
>>
>>/* This is the line before the error occurs and the command used to get
it.*/
>>[root@Casey root]# cat -n po_file | grep 950281 | more
>>950281 INSERT INTO comment_lines
>>VALUES('020750000030009219','09','20','35','N'
>>,' ',00002,'REQUISITIONED BY BILLYBOB
>> ');
>>
>>/* Here is the bad line 950282 below. I put it into it's own test file and
>>tried the command line again. Didn't get an error (with empty and all
>>previous data. */
>>[root@Casey root]# cat test.sql
>>use purchase_orders;
>>INSERT INTO comment_lines VALUES('020750000030009219','09','20','35','N'
>>,' ',00003,' ');
>>
>>
>>/* This is the line after the error occurs and the command used to get it.*/
>>[root@Casey root]# cat -n po_file | grep 950283 | more
>>950283 INSERT INTO comment_lines
>>VALUES('020750000030009219','09','20','35','N'
>>,' ',00004,' ');
>>
>>
>>mysql> describe comment_lines;
>>+-------------------+-----------------------+------+-----+---------+-------+
>>| Field | Type | Null | Key | Default | Extra |
>>+-------------------+-----------------------+------+-----+---------+-------+
>>| po_index | varchar(18) | | PRI | | |
>>| batch_month | char(2) | | PRI | 0 | |
>>| batch_day | char(2) | | PRI | 0 | |
>>| batch_number | char(2) | | PRI | 0 | |
>>| changed_indicator | char(1) | | | | |
>>| maintenance_code | char(1) | | | | |
>>| line_number | mediumint(5) unsigned | | PRI | 0 | |
>>| comment | varchar(40) | | | | |
>>+-------------------+-----------------------+------+-----+---------+-------+
>>
>>
>>
>>root@Casey root]# ls -al po_file
>>-rw-r--r-- 1 root root 468787771 Dec 2 20:56 po_file
>>
>>
>>
>>---------------------------------------------------------------------
>>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
---------------------------------------------------------------------
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
