> Bisa dng 2 cara :
>
> 1.
> $fH = fopen ($fullPathToFile, "r");
> while (!feof($fH)) {
> Parsing file text anda --> bikin sql statement
> insertnya --> Execute
> }
>
> 2. Pakai bulk insert nya mysql LOAD DATA
> Coba lihat manual.txt nya MySql buat syntax command
> LOAD DATA
>
> LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE
> 'file_name.txt' [REPLACE |
> IGNORE]
> INTO TABLE tbl_name
> [FIELDS
> [TERMINATED BY '\t']
> [OPTIONALLY] ENCLOSED BY '']
> [ESCAPED BY '\\' ]]
> [LINES TERMINATED BY '\n']
> [IGNORE number LINES]
> [(col_name,...)]
>
> Shortcut : pakai phpMyAdmin ;)
Gimana kalo pake PostgreSQL?????
__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
--
Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
Informasi arsip di http://www.linux.or.id/milis.php3
