• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to automate import in MYSQL ?

 
Carla carmona
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I there !

I am new to MySQL. I would like to create a script or find a program that would allow me to automate the import of data from a file ( csv, xml or other ) to the relational tables.


Please help !


Carla
 
payal agrawal
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Look at the URL below:

Import Data from Txt or CSV files into MYSQL database tables
http://www.java-tips.org/content/view/354/29/

Java program can be automated by using Task Schedular on Windows and similar program on other OS.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic