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

W

W

WithoutNickname2021-01-31 03:41:37

MySQL

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

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

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

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

N

niakrisn2011-05-16 22:38:45

Backup of disparate databases in MySQL 4Reply

A

alesto2011-05-19 13:22:50

Complex mysql query. Details under the cut 4Reply

I

Ivan Torgov2018-02-14 11:08:36

Why remove the foreign key in order to remove the unique index? 1Reply

F

Funny_Man2018-02-14 13:09:38

How to make Django work with MySQL? 3Reply

A

Alexey Semenyuk2015-10-10 14:38:01

How to create a query from 3 tables? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question