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
