I want to import tsv file into mysql

Asked 2 years ago, Updated 2 years ago, 77 views

I would like to insert the data in the tsv file as a record for the table I am currently creating.It takes endless time to hand in one by one by one.
The tsv file contains the same number of data as the number of fields in the creation table.

In other words, would it be possible to import the tsv file and insert it into the specified table and complete it?

Please teach me.Please let me know if there is any missing information.

mysql

2022-09-30 21:12

1 Answers

I think you can do it using the mysqlimport command or LOAD DATA query.


2022-09-30 21:12

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.