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
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
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]
