Re: How to load text or sql file into mysql commandLine?

[John seito]

ok thanks, the files seems to be loaded but my loaded data doesn't seem come out to the command line correctly.

I have the text file save as this;

id 0,
firstname 'andy',
lastname 'Jay',
email '[e-mail]',
phone '123-435-4234'


I created the database with id as interger,
and all the rest as varchar which is text.

note: that I have tab in between id and 0 and all the other infor on the textfile.

in my command line, id and phone field is blank and all the rest are NULL.

thanks,