Importar csv loadinfile
Galera,
Estou tentando importar um arquivo csv:
Idaut,Data,IdLinha,IdLinhaPrincipal,IdCarro,Turma,IdMotorista,IdCobrador,SaidaGaragem,Iniciante,Encerrante,Passageiros,Bilhetagem,Atualizado,GPS,IdArquivoTXT
1,2010-09-22 00:00:00,13,8,3,2,221,503,2010-09-22 17:03:00, , ,276 ,1,0,0,68
2,2010-09-22 00:00:00,13,8,1,1,193,408,2010-09-22 05:48:00, , ,303 ,1,0,0,202
3,2010-09-22 00:00:00,7,5,4,2,371,371,2010-09-22 17:05:00, , ,196 ,1,0,0,135
4,2010-09-22 00:00:00,11,0,2,1,181,181,2010-09-22 05:30:00, , ,224 ,1,0,0,1
5,2010-09-22 00:00:00,13,8,5,1,0,532,2010-09-22 06:31:00, , ,340 ,1,0,0,69
6,2010-09-22 00:00:00,13,8,1,2,77,526,2010-09-22 14:04:00, , ,417 ,1,0,0,203
7,2010-09-22 00:00:00,31,4,6,1,343,343,2010-09-22 05:57:00, , ,266 ,1,0,0,136
8,2010-09-22 00:00:00,11,0,2,2,292,292,2010-09-22 14:15:00, , ,220 ,1,0,0,2
9,2010-09-22 00:00:00,13,8,5,2,82,493,2010-09-22 16:39:00, , ,160 ,1,0,0,70
10,2010-09-22 00:00:00,1,3,7,1,0,0,2010-09-22 06:16:00, , ,202 ,1,0,0,3
11,2010-09-22 00:00:00,1,3,7,2,0,0,2010-09-22 13:54:00, , ,136 ,1,0,0,3
Mysql:
LOAD DATA LOCAL INFILE 'Guias.csv' INTO TABLE guias FIELDS TERMINATED ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES(Idaut,Data,IdLinha,IdLinhaPrincipal,IdCarro,Turma,IdMotorista,IdCobrador,SaidaGaragem,Iniciante,Encerrante,Passageiros,Bilhetagem,Atualizado,GPS,IdArquivoTXT)
E está gerando o seguinte erro:
Erro ao acessar o banco de dados
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''guias' FIELDS TERMINATED ',' LINES TERMINATED BY ' ' IGNORE 1 LINES(Idaut,Data,' at line 1
LOAD DATA LOCAL INFILE 'Guias.csv' INTO TABLE 'guias' FIELDS TERMINATED ',' LINES TERMINATED BY ' ' IGNORE 1 LINES(Idaut,Data,IdLinha,IdLinhaPrincipal,IdCarro,Turma,IdMotorista,IdCobrador,SaidaGaragem,Iniciante,Encerrante,Passageiros,Bilhetagem,Atualizado,GPS,IdArquivoTXT)
Alguém sabe como me ajudar?
Alguém tem idéia?
Discussão (1)
Carregando comentários...