, October 24, 2002 5:09 PM
AK To: Mysql List (E-mail)
AK Subject: Understanding MySQL column type SET
AK Gurus
AK I'm having trouble understanding the column type SET.
AK To explain my problem, I'll create a table, populate
AK it, and do selects.
AK mysql CREATE TABLE settest( chain SET( A, B, C
mysql CREATE TABLE settest( chain SET( A, B, C ) NOT NULL,
UNIQUE INDEX ichain( chain ) );
mysql INSERT INTO settest SET chain=A,C;
mysql SELECT * from settest;
+---+
| chain |
+---+
| A,C |
+---+
mysql SELECT * FROM settest WHERE chain=A,C;
Gurus
I'm having trouble understanding the column type SET.
To explain my problem, I'll create a table, populate
it, and do selects.
mysql CREATE TABLE settest( chain SET( A, B, C ) NOT NULL,
UNIQUE INDEX ichain( chain ) );
mysql INSERT INTO settest SET chain=A,C;
mysql
,A', chain)0;
Empty set (0.00 sec)
I guess it can be a bug.
-Original Message-
From: Lopez David E-r9374c [mailto:r9374c;motorola.com]
Sent: Thursday, October 24, 2002 5:09 PM
To: Mysql List (E-mail)
Subject: Understanding MySQL column type SET
Gurus
I'm having trouble understanding