mysql fails
| From: | val petruchek | Date: | Tue, 05 Feb 2002 10:55:24 +0000 |
| Subject: | mysql fails | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-83577@lists.php.net to get a copy of this message | ||
Sorry, incorrect subj!
Hello!
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?
Thanx
Valentin Petruchek (aki Zliy Pes)
http://zliypes.com.ua
mailto:val@zliypes.com.ua