Bluehost.com Web Hosting $6.95

newbie question

This is a discussion on newbie question within the MySQL Database forums, part of the Database Forums category; hello. i have a text file which i insert into a table using "load data infile replace" every ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 07-19-2007
anitawa
 
Posts: n/a
Default newbie question

hello.

i have a text file which i insert into a table using "load data infile
replace" every couple of minutes.
the content of the text file changes.
i want to be able to delete all rows in the table that are not in the
text file.

i cant delete the table and load data because its being accessed
constantly.

is there a way to just delete the records in the table that are not in
the file.

thanks in advance

Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 12:17 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0