How to import TSV file into Mysql database

Показать описание

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.

it has 193 records.

Please follow these steps

Step 1: Add the cloumn names to the TSV file
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 :-)