Friday, August 18, 2006 12:37 PM
To: Robert DiFalco; 'mysql@lists.mysql.com'
Subject: RE: More query help for user-defined values
No takers?
-Original Message-
From: Robert DiFalco
Sent: Thursday, August 17, 2006 3:03 PM
To: Robert DiFalco; mysql@lists.mysql.com
Subject: RE: More query
No takers?
-Original Message-
From: Robert DiFalco
Sent: Thursday, August 17, 2006 3:03 PM
To: Robert DiFalco; mysql@lists.mysql.com
Subject: RE: More query help for user-defined values
One simple solution is to denormalize a little and take the refTypeID
column out of StringValue and
ysql@lists.mysql.com
Subject: More query help for user-defined values
To support user defined properties I have the following tables:
TABLE StringType
LONG ID PKEY
VARCHAR name
...
VARCHAR defaultValue
TABLE StringValue
LONG parentID
LONG typeID
VARCHAR val
To support user defined properties I have the following tables:
TABLE StringType
LONG ID PKEY
VARCHAR name
...
VARCHAR defaultValue
TABLE StringValue
LONG parentID
LONG typeID
VARCHAR val
Assume the correct indices are in place. Different string value types
ca