Import from CSV

18/04/2006, 20h25

Using SQLyog 5.02 into MySQL server 5.0. Have built table structures and am
trying to import data from CSV. I get a rather non-descript dialog box
saying only "Error while importing data".

Does anyone have any suggestions on how to better accomplish this import or
how this error could be deciphered?

Steve

18/04/2006, 20h46

use LOAD FILE (see docs if you need the correct syntax.)

18/04/2006, 20h25	#1
GSP@DCS Messages: n/a Hébergeur:	Import from CSV Using SQLyog 5.02 into MySQL server 5.0. Have built table structures and am trying to import data from CSV. I get a rather non-descript dialog box saying only "Error while importing data". Does anyone have any suggestions on how to better accomplish this import or how this error could be deciphered? Steve

18/04/2006, 20h46	#2
onedbguru@firstdbasource.com Messages: n/a Hébergeur:	Re: Import from CSV use LOAD FILE (see docs if you need the correct syntax.)

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email