phpmyadmin - How to import csv file into database without losing leading zeros of numbers in columns -


i exported database table csv file, modified , trying reimport it. columns having data "001", "002", "003" etc type text becomes "1", "2", "3" on importing database via php myadmin, meaning loosing leading zeros.

please help

problem solved when converted file sql format online csv sql converter. opened file in notepad++ , made sure structure of fields , table same previous file. , when uploaded file, leading zeros retained.


Comments