LibreOffice Base Macro run MySQL command ENCLOSED BY (and the enclosed are by qotation markes aka "

Jean Charles Dreyfus 0
Viewed 6

Im doing a macro in Libreoffice extract a txt file to mysql but all data has "double quotes".

in mysql terminal this command works fine. LOAD DATA INFILE '/var/lib/mysql-files/Stock.txt' INTO TABLE StockXLS FIELDS TERMINATED BY ';' ENCLOSED BY '"' IGNORE 1 LINES;

in macro like this it works oStatement.execute("LOAD DATA INFILE '/var/lib/mysql-files/Stock.txt' INTO TABLE StockXLS FIELDS TERMINATED BY ';' IGNORE 1 LINES;")

but if i add ENCLOSED BY '"' I get erro. oStatement.execute("LOAD DATA INFILE '/var/lib/mysql-files/Stock.txt' INTO TABLE StockXLS FIELDS TERMINATED BY ';' ENCLOSED BY '"' IGNORE 1 LINES;")

Thank you for your help

libreoffice mysql database
1 Answers

I found the solution

oStatement.execute("LOAD DATA INFILE '/var/lib/mysql-files/Stock.txt' INTO TABLE StockXLS FIELDS TERMINATED BY ';' ENCLOSED BY '" & """" & "' IGNORE 1 LINES;")

Jean Charles Dreyfus0
Related