Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Programmers Tech >> Developer Tech >> Database

trasfer text from textfile to mysql

Hi All,
I have one text file, now if i want to transfer the text of this file into mysql is there any direct available in sql. I have already tried load command but it does not work.

[198 byte] By [chintucs] at [2007-11-11 10:14:30]

«« Fixed position/size windows in an MDI application
»» Is this efficient?

# 1 Re: trasfer text from textfile to mysql

What happens when you use LOAD DATA INFILE?

pclement at 2007-11-11 23:43:21 >

# 2 Re: trasfer text from textfile to mysql

when i try to run this command then it says this version does not support this.

chintucs at 2007-11-11 23:44:26 >

# 3 Re: trasfer text from textfile to mysql

What version of MySQL are you using?

pclement at 2007-11-11 23:45:25 >