Empty table in mysql after I loaded the data in
===

I created a table in mysql and loaded the data in with the following code:

drop table if exists apriori_1_to_1_bic;

create table apriori_1_to_1_bic (
rules integer
,bic_1 varchar(10)


,bic_out varchar(10),support double
,confidence double
,lift double
);


load data infile "/s-drive/clients/e/apriori/personalisation/Rules/rules_jb_1_to_1_bic_cleaned.txt" into table apriori_1_to_1_bic fields terminated by "\t" lines terminated by "\r\n" ignore 1 lines;

show warnings;


No warnings were displayed, but the table remains empty.