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
