maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

i openned a MDEV: https://mariadb.atlassian.net/browse/MDEV-9073
and will upload this last example

2015-11-03 0:50 GMT-02:00 Roberto Spadim <roberto@xxxxxxxxxxxxx>:

> well some conversion is done....
>
> SQL:
> drop table if exists a;
> create table if not exists a(i bit(64)) ENGINE=MYISAM;
> LOAD DATA LOCAL INFILE "c:\\spadim\\t.txt"
> IGNORE INTO TABLE `a` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n'
> (i);
> select * from a;
>
> RESULT:
> i
> 00001101
> 00001101
> 00001101
> 00001101
> 00001101
> 00001101
> 00001101
> 00001101
>
>
> file t.txt attached
> [image: Imagem inline 1]
>
>


-- 
Roberto Spadim
SPAEmpresarial - Software ERP
Eng. Automação e Controle