How to import csv MySql?

pemoch's profile image pemoch posted 2 years ago in Import/Export Permalink

I get an error: / Ошибка SQL (2): File 'c:\Users\Root\Downloads\БД8.csv' not found (Errcode: 2) /

Table

CREATE TABLE `players`(    
    `id` INT(5) NOT NULL AUTO_INCREMENT,       
    `first_name` VARCHAR(255) NOT NULL COLLATE 'utf8_unicode_ci',
    `last_name` VARCHAR(255) NOT NULL COLLATE 'utf8_unicode_ci',
    `fio` VARCHAR(255) NOT NULL COLLATE 'utf8_unicode_ci',
    `position` VARCHAR(255) NOT NULL COLLATE 'utf8_unicode_ci',
    `resume` TEXT NOT NULL COLLATE 'utf8_unicode_ci',
    `number` INT(11) NOT NULL,
    `image` VARCHAR(255) NOT NULL COLLATE 'utf8_unicode_ci',
    `user_name` VARCHAR(20) NOT NULL COLLATE 'utf8_unicode_ci',
    PRIMARY KEY (`id`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=7
;

Pic-1
Pic-1

Pic-2
image description

Pic-3
image description


Pic-4
image description

Pic-5
image description


Pic-6
image description

Pic-7
image description

Pic-8
image description

Pic-9
image description

Pic-10
image description

Pic-11
image description

pemoch's profile image pemoch posted 2 years ago Permalink

File csv

1 attachment(s):
ansgar's profile image ansgar posted 2 years ago Permalink

Wow, 11 images to describe one error?

Well, you need to update HeidiSQL as I guess you are not on the latest v12.0, right? The filename is the problem, MySQL can't handle non-latin1 characters in the filename. So HeidiSQL v12.0 uses the 8+3 version of the filename. See also issue #1387.

pemoch's profile image pemoch posted 2 years ago Permalink

Works. Thanks.

Please login to leave a reply, or register at first.