Importar csv loadinfile

[leandroauler 0]

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?

[C. Medeiros 0]

Você está rodando isso pelo PHP(ou outra linguagem) ou direto no banco por SQLYog, Toad? Me parece mais erro de aspas do que de comando...