Error SQL-query in importing file

[infinite_root]

Hi Everyone,

Had this problem importing our previous database (.dbf) into MySQL.

I had these report history.dbf which I converted into .txt file to be imported into MySQL using phpMyAdmin.

However, everytime I attempt the import the following error appeared:

Error
SQL-query :
INSERT INTO history
VALUES (
'00000', '050VOA', '050', 'OLR', '19841126', '19851108', '11', '0', '', 'TAIWO', '', 'PHIL. TRANSMARINE CARRIERS', '' , , , '12', '', '', ''
)
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ','12','','','')' at line 1

Here's somepart of history.txt:
# Structure Definition for Master Table 'history'
#
CREATE TABLE history (CREWCODE CHAR(5) NOT NULL,VESSEL CHAR(6) NOT NULL,PRINCIPAL CHAR(3) NOT NULL,RANK CHAR(8) NOT NULL,SIGNONDATE CHAR(8) NOT NULL,SIGNOFDATE CHAR(8) NOT NULL,MONTHS CHAR(2) NOT NULL,TERMNCODE CHAR(2) NOT NULL,QUALNCODE CHAR(2) NOT NULL,VSSLNAME CHAR(40) NOT NULL,VSSLTYPE CHAR(29) NOT NULL,REMARKS CHAR(30) NOT NULL,FAXINFO CHAR(25) NOT NULL,NOTES LONGBLOB NULL,NFRREMARKS LONGBLOB NULL,DAYS CHAR(2) NOT NULL,GROSS CHAR(30) NOT NULL,ENGINE CHAR(40) NOT NULL,MEDINFO CHAR(25) NOT NULL,MEDICAL LONGBLOB NULL);
#
# Data for Table 'history'
#
INSERT INTO history VALUES('00000','050VOA','050','OLR','19841126','19 851108','11','0','','TAIWO','','PHIL. TRANSMARINE CARRIERS','',,,'12','','','',); // Line 1: this is where the problem emanated

INSERT INTO history VALUES('00000','050VOA','050','OLR','19860518','19 870203','8','2','','TAIHO','','PHIL. TRANSMARINE CARRIERS','',,,'15','','','',);

INSERT INTO history VALUES('00001','050VOA','050','A/B','19840721','19880404','44','2','','NO.3 KENDARI','LOGSHIP','ABACAST','',,,'13','','','',);

INSERT INTO history VALUES('00001','001FWL','001','O/S','19880905','19900118','16','2','','FINNWHALE',' BULK','','',,,'13','','','',);

INSERT INTO history VALUES('00001','001FBR','001','A/B','19900510','19910517','12','2','','FINNBEAVER', 'BULK','','',,,'7','','','',);

INSERT INTO history VALUES('00001','010NPN','010','A/B','19911018','19920901','10','2','','CPC NIPPON','HEAVY LIFT','','',,,'13','','','',);

Do you see any problem? How can I overcome this? Hope you can help me.

Thank you very much.

More power!

[sde]

there are 2 blank fields before the 12. try placing the word NULL in them:

'',NULL,NULL,'12'

if you don't want them to be null, then put 2 single quotes

'','','','12'