HI ALL,
I am new bie to mysql...I have 100 files as text files and each text file are having minimum 25 lines.I want to enter all the files in to Mysql DB.
My query is, In mysql table, i have a columns like pid(PRIMARY KEY),content(LONGBLOB).
In table, Pid has entries like p1,p2,p3.....
Now in a directory, i have text files like p1.txt,p2.txt,p3.txt.....
I want to upload the text files into content(LONGBLOB) column field, if the PID and the textfile names are same.
CAN ANYONE HELP ME TO UPLOAD THE TEXT FILES..
Please it's urgent.
Thanks in advance...