On Tue, 2006-06-06 at 07:47, Denny Zulfikar wrote:
> #----------start-------------
> FILES="/mnt/serverku/test_out/060530.txt"
>
> for file in $FILES
> do
> mysql -u root --password=pswd table_ku -e "LOAD DATA INFILE "$FILES" INTO
> TABLE lpc"
> done
> #--------------eof-----------------
Ok mas deny
Thanks atas bantuannya
kalo gini kira-kira yg salah apa yah ?!
padahal sintaxnya udah sesuai sesuai dengan "Primbon":
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE '/|file_name|/.txt'
[REPLACE | IGNORE]
INTO TABLE /|tbl_name|/
[FIELDS
[TERMINATED BY '/|string|/']
[[OPTIONALLY] ENCLOSED BY '/|char|/']
[ESCAPED BY '/|char|/' ]
]
[LINES
[STARTING BY '/|string|/']
[TERMINATED BY '/|string|/']
]
[IGNORE /|number|//|col_name_or_user_var|/,...)]
[SET /|col_name|/ = /|expr|/,...)] LINES]
[(/|col_name_or_user_var|/,...)]
[SET /|col_name|/ = /|expr|/,...)]
FYI, kalo saya make single file ternyata udah bisa
#------------
FILES="/mnt/serverku/test_out/060530.txt"
for file in $FILES
do
mysql -u root --password=pswd table_ku -e "LOAD DATA INFILE '$FILES' INTO
TABLE lpc"
done
#----------
tapi kalo coba pake :
FILES=`ls /mnt/serverku/test_out/060530.txt`
hasilnya, for udah bisa jalan, tapi muncul ERROR ginian:
# sh coba.sh
ERROR 13 at line 1: Can't get stat of '%s' (Errcode: 36)
ERROR 13 at line 1: Can't get stat of '%s' (Errcode: 36)
ERROR 13 at line 1: Can't get stat of '%s' (Errcode: 36)
ERROR 13 at line 1: Can't get stat of '%s' (Errcode: 36)
dst
atas bantuannya, makasih bangett
salam,
yanu
--
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis
