Hello val, > a have following mysql problem: > i need to execute several inserts at one query like this-> > > $sql->action("insert into words(word) values ('php'); > insert into words(word) values ('general'); > insert into words(word) values ('list');"); > > The word fild is unique > > My problem is: when certain word (e.g. 'php') already exists in table words > all the query fails > > I do not want to check every word on existance and then insert only "new" > words. > > I want mysql to ignore fails. How can i do it?
MySQL manual 6.4.3 INSERT Syntax Check out INSERT [IGNORE] Regards, =dn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php