Hi;
New subscriber to the list, searched the archives for any thread on this
with no joy so
sorry if it's a re-post.
Can I have 2 bind-addresses in my.cnf ?
Changing ports is not an option.
Dual honed Sun Box running MySQL 4.x
Thnks
Scot Needy
[EMAIL PROTECTED]
757-664-2217
Yah
lated, issue
selects for each of the unique contrained columns to determine which one was
violated"?
Thanks
From: Jeremy Zawodny <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Scot Campbell <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Unique Key Violation - How
ns the non-duplicate data (i.e., error message on the email address
vs. error message on the userid field).
From: Jeremy Zawodny <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Scot Campbell <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Unique Key Violation - How to de
uniqueness via individual selects before I issue the insert.
Thanks
From: Jeremy Zawodny <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Scot Campbell <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Unique Key Violation - How to determine which key
Date: Tue, 16 Sep 2003 20
I have a table w/ a primary key and 2 additional unique keys.
How can I determine which key was in error when a key violation occurs
(error=1062)?
The call is issued from PHP (4.4.3).
I can retrieve a message w/ mysql_error() which returns "Duplicate entry
'[EMAIL PROTECTED]' for key 3"
I'd r
0010519161625 |
++
1 row in set (0.04 sec)
When I display the result, I would like reformat it so that it reads:
05-19-2001 16:16:25
- OR -
May 19, 2001 04:16:25
Anybody out there that can tell me how this is done? Thanks!
Scot Robnett
[EM
