Inserting tab delimited textfiles into mysql
| From: | Thomas Goeminne | Date: | Thu, 19 Dec 2002 11:31:23 +0000 |
| Subject: | Inserting tab delimited textfiles into mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-128846@lists.php.net to get a copy of this message | ||
I got a tab delimited file which looks like this:
let us call it items.txt
Type Catalog Number Item Description Side B Producer
12 AAA502 Afu Ra-D&D Soundclash Mic Stance, Premeir,Curt Cazall
12 AC725 Roc Raida/Wayne-O - Gong Show Burn That Ass Roc
Raida
I want to take all this info and insert it into my mysql dbase. The type is
in a table named categories. The rest should go into the table named items.
With also the id number off the categorie in it.
I have been looking for info on how to do this but I can't find a decent
article about it. First off I dump all the records which were already in the
dbase. And then it needs to get filled up with the new items.txt
I would appreciate your help
greets
--
Thomas Goeminne