I'm parsing some xml, I want to loop the output into the database.
Only thing is that I want to replace the total contents of the database with the xml file results, so I guess I could use:
DELETE FROM tblName
is there a better way of doing things?
I'm trying to use the REPLACE method now, which I didn't realise existed until just after I posted that :rolleyes:
Although, as we know it only replaces if the primary key matches and the data does not, in which case it will just INSERT the data.
How can I do this?
