MySql insert bit using tab delimited
===

I am using a tab delimited file to insert data into MySql database

in bit field I got 0 and 1 as a value but when I insert the data into the database using the command below it is converting 0 to 1.

    load data local infile 'c:/membership.txt' into table membership;

as a result the bit column on has value 1 in every row.