I have this problem when importing database froman excel file to mysql via phpmyadmin.
the table structure is : Id(int), Serial(varchar), Name(varchar)
I have the similiar tabel in the excel file where the Id field has a number format and the Serial and Name fields have text format
the problem is : when I import this excel file via phpmyadmin, mysql always determine the Serial field as integer, not as varchar.
Anybody can help me to solve this problem?