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

[Back to original message]