to import excel file into mysql

Binefş Aslan

8y1.1kSQL

Hey guys,

i want to import an excel sheet into mysql. there is no mistake in the code, but the excel can not been find. What i am doing wrong ?

this is my code:

create database if not exists ceribandin;

use ceribandin;

create table if not exists boats (

Begriffsbezeichnung INT NOT NULL PRIMARY KEY,

Wert VARCHAR (100),

Zustand VARCHAR (45),

Seriennummer INT,

Preis FLOAT);

Load data local infile "G\:PROJE, CERIBANDIN C#\ceribandinek.csv" into

table ceribandin.boats

fields terminated by ','

lines terminated by '\n'

ignore 1 lines

(Begriffsbezeichnung, Wert, Zustand, Seriennummer, Preis);

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar8y ago
Please check below link

https://www.tutorialspoint.com/How-can-we-tackle-MySQL-error-ERROR-1290-HY000-The-MySQL-server-is-running-with-the-secure-file-priv-option-so-it-cannot-execute-this-statement-while-importing-or-exporting-the-data
Binefş Aslan8y ago
Hey, thanks.
i tried it in the way you wroted but it shows error 1290
Jignesh Kumar8y ago
Hi,

If you are using My SQL to load data from .csv file in comma separated then you have to write like below

LOAD DATA INFILE 'c:/ceribandineck.csv'
INTO TABLE discounts
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;