i am sort of confused about the SET column type... is there any place that
i
can go that will give a better example of it and how to use/create it than
the manual does??
If you read the user comments on the manual page
(http://dev.mysql.com/doc/mysql/en/SET.html) you'll see loads of examples
hi..
i am sort of confused about the SET column type... is there any place that i
can go that will give a better example of it and how to use/create it than
the manual does??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I've bene trying to find info on how efficient queries are for the SET
datatype, specifically, how does
MySQL use indexes for SET column types.
I have looked in the O'Reilly MySQL Reference Manual, and at mysql.com and
have found effectively nothing on this subject.
For example, if i have a table
there). You can easily test
for yourself by trying
SELECT FIND_IN_SET( 1, -5,0,1,4,5, )
that it not even requires a column.
The thing is, I cannot make it set column-type, since I have no idea
what values it will be holding, but at the same time it will be
comma seperated list of integers. So I'll