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 ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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 |