How to import data from a text file into a database?

W

WithoutNickname2021-01-31 03:41:37

MySQL

WithoutNickname, 2021-01-31 03:41:37

There is a text file of the format:
id1
id2
id3
etc.
How can I transfer all the contents of a text file to the database? Each line of the text file is one record in the database.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

I

idShura, 2021-01-31
@idShura

LOAD DATA Statement

Similar questions

P

PEKTOP2014-05-15 16:47:54

Why did git pull start saving files as root? 7Reply

A

Anton2021-03-27 12:39:53

Getting the selected radio item and passing it to the email body, how to display the selected item? 2Reply

R

Roman Gamretsky2014-05-27 17:47:30

How to dynamically replace PartialView in one page? 4Reply

R

Rostyk Ice2015-05-16 22:23:57

How to restore scripts in Tampermonkey with only the old Chrome folder? 3Reply

V

vldanch2018-12-19 22:59:56

How to write ai? 6Reply

Didn't find what you were looking for?

Ask your question