How to import TSV file into Mysql database

Опубликовано: 02 Октябрь 2018
на канале: 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 :-)

Смотрите видео How to import TSV file into Mysql database онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь TechiesBadi 02 Октябрь 2018, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 7,267 раз и оно понравилось 32 людям.

14,642

00:00:00