Hi Andreas,
On Sat, 2002-02-16 at 08:52, Andreas Frøsting wrote:
> Why does MySQL have this strange behavoir, treating unique indexes
> case-insensitive?
> Can anyone explain MySQL's behaviour and how I do a workaround making
> unique indexes and primary keys case sensitive?
> I've been over the
Hi there,
I'm having som difficulties trying to figure out MySQL's unique indexes
and primary keys.
Case:
mysql> create table flaf (lala varchar(20) not null, unique(lala));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into flaf VALUES ('hest');
Query OK, 1 row affected (0.00 sec)
my
On Sun, Mar 18, 2001 at 03:58:46PM -0500, Ryan Shrout wrote:
>
> Could someone explain to me the difference between the
> Primary/Index/Unique attributes of MySQL? I am coming from using MS
> SQL where there is only the Primary key option.
And INDEXed column may have duplicate values in it. A UN
Could someone explain to me the difference between the Primary/Index/Unique attributes
of MySQL? I am coming from using MS SQL where there is only the Primary key option.
Sorry if this is too beginner of a question for this list.
Ryan Shrout
Athlonmb.com
Production Manager
http://www.athlonmb.