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