Hi, Just set a unique index on the right column and you won't have anymore duplicate in your table :)
ALTER TABLE yourtable ADD UNIQUE(your_column); Regards, Jocelyn Fournier Presence-PC ----- Original Message ----- From: "Craig Westerman" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Saturday, March 16, 2002 3:38 PM Subject: MySQL - check for existing data > I have a db table that receives weather data several times a day via a php > script and cron job. Sometimes the data is duplicated for a certain time > window. > > 11:50 44 degree > 11:50 44 degree > 11:40 45 degree > 11:30 46 degree > 11:20 46 degree > 11:10 45 degree > > I do not want the duplicate data for the 11:50 time slot to be inserted into > my table. Is there a common method used to check if data already exists in a > db table and if so to cancel the data insertion? What is this called? Is > this demonstrated in the MySQL book or documentation. If I knew what this > was called, I might have better luck finding solution. > > Thanks > > Craig ><> > [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
