Re: MySQL load data with ANT
- From: "Ray in HK" <ray@xxxxxxxxx>
- Date: Mon, 27 Jun 2005 18:15:32 +0800
solved,
simply as normal ant variable ${}
"Ray in HK" <ray@xxxxxxxxx> ¦b¶l¥ó news:42bfc61d$1@xxxxxxxxx ¤¤¼¶¼g...
> 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.
>
>
.
- Prev by Date: Re: problem with timestamps in HSQL
- Next by Date: RefCursor works in SQL*Plus but not JDBC
- Previous by thread: problem with timestamps in HSQL
- Next by thread: RefCursor works in SQL*Plus but not JDBC
- Index(es):
Relevant Pages
|
|
