Creating tables

[gokuzboy]

Hi, I have a question about inputing data into mysql database table.
Here is my problem. I can insert data into mysql on command prompt by doing something like this: source myfile.sql

however I want to do this in java code. is there any possible way of doing this.

Ex public getData( ){
....
//run some sort of source myfile.sql here
}

Thanks,

Mark

 

[sleipnir214]

The canonical way to contact databases from Java is through ODBC:

http://www.mysql.com/downloads/api-jdbc.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!