I recently saw and article that says MySQL will be shipping its cluster software
starting April 14th during the Users Conference & Expo this year. Does anyone have
any information about this? My company is considering using the Emic clustering
software. Has anyone had experience with that? W
Someone told me that it is possible that MySQL will automatically change
column types in certain situations. For example the a table with a char(5)
type field might dynamically change to a varchar(5) type field. So a static
length column to a variable length column. Is this possible? If so what a
Is there any difference in speed between the following select statements?
SELECT yada,yda FROM test WHERE id IN(1,2,3)
OR
SELECT yada,yda FROM test WHERE (id =1 or id = 2 or id =3)
Could anyone tell me the difference between the following two explains? It
seems the first takes longer to execute.
This first query is like so...
select m.*, mi.age from members m, members_addtl_info mi where m.nick
like '%anynickname%' AND m.nick = mi.nick order by nick desc,
account_login_las
Hello everyone. I have copied the results from and explain on a query that I want to
use. And I am wondering if anyone could tell me if these results are bad or good?
If everything below is coming up garbled for you I will basically I am using 7 tables
and the rows for 6 of the seven are 1 and t
Hi,
Is there a way I can run a query that will delete all items that are not in
a list? For example I have a bunch of records in a table and I want to
remove all of them that are not in a comma delimited list that I have
recieved from another application. I was thinking that I could create a
que
