Re: [Maria-discuss] LOAD FILE and BIT datatype

3 Nov 2015


      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@spadim.com.br>:
...
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