|
|
Posted by Rik on 07/16/07 18:37
On Mon, 16 Jul 2007 20:28:01 +0200, nelson.salvador@gmail.com
<nelson.salvador@gmail.com> wrote:
> Hi all,
>
> I need some help...
>
> My Example:
>
> Field: Bank Account Nº: 12353545456 & Field: Bank Account Nº: (Empty)
>
> The nº must be unique but could be empty also...
>
> What is the SQL? It's Possible?
Allow NULL values, and use that for unknowns. So not an empty string, not
0, but NULL.
AlTER TABLE table ADD UNIQUE(`bank_acccount`);
--
Rik Wasmus
Navigation:
[Reply to this message]
|