One Star

how to import csv file into MYSQL DB table, with automatic datatypes

hi all..
An advice needed to import csv file into a MYSQL DB table.
In my csv there are 200 clms,
Is there any way that automatically assigns datatypes for the clms in MYSQL while importing csv file as in MS SQL SERVER.
Thanks 
VK
1 REPLY
Twelve Stars

Re: how to import csv file into MYSQL DB table, with automatic datatypes

Fully automatic - not
You can add file schema to repository - and then it guess schema for You, after this You will need check and fix if any mistakes
      
-----------