Menu
Community /Pin to ProfileBookmark
*****************
@NogDogJun 01.2011 — #Usually the best way is to set up a "unique" index on the columns that you do not want duplicated. Then when you want to do a data insert, either use MySQL's "REPLACE INTO " command (instead of an "INSERT"), or since that is a non-standard SQL command, instead use the "INSERT INTO . . . ON DUPLICATE KEY " syntax.
insert avoiding duplicate data
Hi
I have a website conected to a db. I add data automatically via php INSERT. I get data from csv and xml, an dthen INSERT into db
My problem, is that I duplicate data, so my db grows a lot.
How can I check if the data already exists? I was trying this code, but it does not work.
*****************
$query = “SELECT * FROM val WHERE lake_id=’$lai’ AND parameter_id=’$ipa’ and valu=’$vpa’ AND date=’$fe'”;
$results = mysql_query(“SELECT COUNT(
$name = mysql_result($results,0);
if ($name > 0) {
echo “existe”;
Sign in
to post a comment1 Comments(s) ↴
0
@NogDogJun 01.2011 — #Usually the best way is to set up a "unique" index on the columns that you do not want duplicated. Then when you want to do a data insert, either use MySQL's "