mysql load data, issue with boolean field

Question

I m loading data in a mysql table with the instruction :

LOAD DATA LOCAL INFILE "/home/user123/Documents/PartageVB/export tables/pays.csv" INTO TABLE T_PAYS FIELDS TERMINATED BY ";" LINES TERMINATED BY "\n"(id, name, cit,actif);

In the file pays.csv, the column cit is boolean, and gets the value 1 or 0.

My problem is that once LOAD DATA is done, cit always gets the value 1 in the mysql table.

Does anyone know where I m wrong?

In the table, cit type is Bit(1).

Thanks

Community · Accepted Answer · 2017-05-23 12:20:34Z

3

Please use "TINYINT(1)" instead of "Bit(1)".It might work. Refer this link

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Jan 6, 2015 at 8:00

adarsh hota

32711 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql load data, issue with boolean field

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related