I think you could do this.
Load all the data.
Then "delete from table where name != extension"
At 08:01 PM 1/30/01 -0500, Mark @ 10base-t wrote:
>Hey there,
>Can you use the load data infile command to load stuff in only if certain
>fields match? Or would I have to do this via some php loop?
>
>Basically I have a txt file with 5 fields in it. First name, extension,
>space, seat, cluster.
>
>I only wanna update a record with the space seat and cluster information as
>long as the extension and first name are a match.
>
>Thanks!
>Marky
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
