How to import TSV file into Mysql database

Published: 02 October 2018
on channel: TechiesBadi

7,267

How to import TSV file into Mysql database
-----------------------------------------------------------------------
Actually, there is no direct import option on the PHPMyAdmin it accepts the only some specified formats only.

But we can easily import the TSV file data into the MySql Database.

Generally, A TSV file stores a data table in which columns of data are separated by tabs.

For example here iam taking the area_master.tsv file.

it has 193 records.

Please follow these steps

Step 1: Add the cloumn names to the TSV file
Step 2: Open this link https://www.beautifyconverter.com/tsv...
Step 3: Copy the TSV file contents & paste on the website texarea
Step 4: Enter the Table name
Step 5: click on the SQL insert button
Step 6: Copy the Sql statements and paste it on the mysql database in phpmyadmin and execute

That's it.

Thanks for watching
For more technical videos please subscribe our channel TechiesBadi

Keep watching :-)

Watch video How to import TSV file into Mysql database online without registration, duration hours minute second in high quality. This video was added by user TechiesBadi 02 October 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,267 once and liked it 32 people.

6,311

109