Re: MySQL load data with ANT : JDBC JAVA
This is a discussion on Re: MySQL load data with ANT within the JDBC JAVA forums in Framework and Interface Programming category; solved, simply as normal ant variable ${} "Ray in HK" <ray @ hkaskme.a> 在郵件 news:42bfc61d$1 @ 127.0.0.1 中撰寫... > if I want to load csv file thru ant script, how can I specify the directory > by pointing to variable ? > In the following script , I would like to specify "test_date.csv" file > located in the same directory as the project root directory. How can I do > this ? > > <target name="loadData"> > <echo message="LOAD DATA USING: ${db.driver} ${db.url}"/> > <sql driver="${db.driver}" > url="${db.url}" > userid="${db.user}" > password="${db.pw}" > onerror="continue"> > <classpath refid="master-classpath"/> > > LOAD ...
 |
| | LinkBack | Thread Tools |
|
#1
06-27-2005, 05:15 AM
| |||
| |||
 Re: MySQL load data with ANT simply as normal ant variable ${} "Ray in HK" <ray@hkaskme.a> 在郵件 news:42bfc61d$1@127.0.0.1 中撰寫... > if I want to load csv file thru ant script, how can I specify the directory > by pointing to variable ? > In the following script , I would like to specify "test_date.csv" file > located in the same directory as the project root directory. How can I do > this ? > > <target name="loadData"> > <echo message="LOAD DATA USING: ${db.driver} ${db.url}"/> > <sql driver="${db.driver}" > url="${db.url}" > userid="${db.user}" > password="${db.pw}" > onerror="continue"> > <classpath refid="master-classpath"/> > > LOAD DATA LOCAL INFILE '<???>test_data.csv' > INTO TABLE HSI_DAILY > FIELDS TERMINATED BY ',' > LINES TERMINATED BY '\n' > (column1, column2, column3............................. ); > </sql> > </target> > > > Thanks for any comment. > > |
|
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Feeding data into MySQLdb LOAD DATA from Python | usenet | Python | 2 | 11-15-2007 02:57 AM |
| sequel problem: no such file to load -- mysql (LoadError) | usenet | RUBY | 7 | 09-22-2007 02:30 PM |
| Help to retrieve data from mysql | usenet | PHP | 1 | 08-22-2007 10:45 PM |
| mysql data with HTML::BarGraph | usenet | Perl | 1 | 09-28-2006 01:58 PM |
| getting mysql-data with jconnector | usenet | JDBC JAVA | 2 | 12-17-2004 12:17 PM |
