Syndax error on base with LOAD DATA

asked 2015-01-24 21:40:51 +0200

alain.fontaine.566 gravatar image

I enter the following request LOAD DATA INFILE 'v:/work/dev/tdl/data.sql' INTO TABLE TBL_TACHES FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n': Table exists file exists and is compliant then I got a SQL syntax error w/o any information LibreOfice 4.3 Thanks

edit retag flag offensive close merge delete


Spelled: Syntax

EasyTrieve gravatar imageEasyTrieve ( 2016-11-07 18:07:16 +0200 )edit

Without any further information as to which database you have exported from and which database to are attempting to load data into, it is unsurprising that no one has come forward with a suggestion. For these kinds of operations, it is usually better to attempt them from a terminal or an interface that specifically allows for DDL/DML operations. The Query UI in LibreOffice does not allow this, only SELECT requests are allowed. The Tools > Options > SQL allows most (but not always all) DML/DDL statements, and errors are sometimes not always reported in the most useful way.

Alex Thurgood gravatar imageAlex Thurgood ( 2019-02-22 11:52:23 +0200 )edit