Hello everyone, not how I can not deal with LOAD DATA IN FILE, here is an example of my problem

There is a file 1.txt its structure:

.... Молоко Кефир Бидончик Йогурт Вода Водка Воды ....

Suppose there are 300 thousand words.

I need to load these words into the database are valid: base

Here is the base structure and tables.

 /* Создание основной базы данных. */ CREATE DATABASE `base`; /* Работа с базой данных base. */ USE `base`; /* Создание таблицы list. */ CREATE TABLE `list` ( `slovo` varchar(32) NOT NULL DEFAULT '', `md5slovo` varchar(32) NOT NULL DEFAULT '', PRIMARY KEY (`slovo`) );

I need to add words from the 1.txt file to this table via load data in file but in the file one column of rows and in table 2, I need to first add the contents of the file, that is, all the words from the slovo field and in the md5slovo field add the MD5 hash from of this word, I know that there is something like select md5 ( admin ) but I don’t know how to use ...

    1 answer 1

    First request:

     LOAD DATA INFILE 'file_name.txt' INTO TABLE `list` LINES TERMINATED BY '\n' (`slovo`)

    Second request

     UPDATE `list` SET `md5slovo` = md5(`slovo`)

    PS If the file is downloaded from the client host, then in the first request add LOCAL

     LOAD DATA LOCAL INFILE ...