the pointer to use locking, and for the
pointer to InnoDB and BDB. I didn't know about those options.
--
Anand Buddhdev
Celtel International
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can't do in the above way. You can first check with SELECT
> statement if address or alias already exists.
Ok, thanks for the response.
The problem with first doing a select, and then an insert, is that
there exists a race condition. Between the select and insert, someone
else could
of an address and its alias in one insert, and if the insert
fails, then we know there's duplication, and return an error message.
I have thought of other ways around this issue, but my ideal solution
would be as above. If this is not possible, then I will go back to my
other (IMHO less elegan
