Re: load data conditionally

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: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net >