Hi There,
I have a site where people can "watch" certain products with certain specs... this is added to a Mysql database. Is there an Insert type command (such as DISTINCT when you select) so that it only enters the info once?
ie.
INSERT INTO mytable VALUES(3442422,1,0,0,1,1,1,0,1)
I want this only to be added to the database once... although should 1 number change, it should be able to be added again....
Any help would be appreciated.
-dr
I have a site where people can "watch" certain products with certain specs... this is added to a Mysql database. Is there an Insert type command (such as DISTINCT when you select) so that it only enters the info once?
ie.
INSERT INTO mytable VALUES(3442422,1,0,0,1,1,1,0,1)
I want this only to be added to the database once... although should 1 number change, it should be able to be added again....
Any help would be appreciated.
-dr