I am a student of the MTech course
and my problem is:
I have some information of the customer (like his name,credit card number ) that visited my site and buy something ( as my project is an Online shop ). I am now storing his information in a file by separating the columns by "|" mark and taking them a tokenizer class values and manipulating the information.
Now I want to store the information into My Sql insted of files.Can I convert the file directly to Mysql data base Is there any tool for that.And I am using RedHat linux 8.0 and J2SDK 1.4.1 and MySql with Tomcat webserver..
Thanks
mukesh
-
can I convert txt file to MYSQL (1 messages)
- Posted by: Mukesh GVSSR
- Posted on: May 06 2004 01:46 EDT
Threaded Messages (1)
- can I convert txt file to MYSQL by stephen smithstone on May 06 2004 02:07 EDT
-
can I convert txt file to MYSQL[ Go to top ]
- Posted by: stephen smithstone
- Posted on: May 06 2004 02:07 EDT
- in response to Mukesh GVSSR
there is a mysql import routine which you run that tells mysql how the column rows are seperated or you could parse the file using java and use simple jdbc insert commands