Re: Matching subtables

Sebastian Mendel wrote: Werner Van Belle schrieb: Hello, You might find the following challenging -or- you might now the answer :-) Table Q Subtable, field, val, ID A 1 a42 A 2 b42 B 1 a78 B 2 t78 B 3 o78 C

Re: Index/Range Problem?

Dave schrieb: Hi all, I've been trying to optimize some of our queries against a large database and come up against an index problem I haven't been able to find any documentation on. I've cut the query down to the bare minimum, and found the following -- explain Select iname,domain,serv,time

Re: Index/Range Problem?

Hi, Thanks for the help; that makes sense I think you guys are right. Is it worth tuning such a thing? It seems to me like it would be much faster to use the index? Thanks again Dave Dave schrieb: Hi all, I've been trying to optimize some of our queries against a large database and come

revoke all on *.* ??

dear all mysql 5.0.51a, very basic config thus I don't think could be of any relevance here there is a user with following grants: GRANT USAGE ON *.* TO 'ff'@'localhost' IDENTIFIED BY PASSWORD '077042fb4932b5b5' is it possible to: revoke all on *.* from $above_user OR revoke usage on *.*

RE: revoke all on *.* ??

Pawel- the syntax is GRANT USAGE ON DB.* to '[EMAIL PROTECTED]' IDENTIFIED BY PASSWORD 'NeverShowYourPasswordInEmail' http://dev.mysql.com/doc/refman/5.0/en/grant.html HTH Martin Gainty __ Disclaimer and confidentiality note Everything in this

Fw: mysql query, min, max with where conditions

Well, if your particular problem has a well defined maximum minimum and minimum maximum (Ie the max(q) 4294967296, because q is a 32 bit unsigned int, and min(q) -1) then you can do it without any extra joins or sub selects. select a, b, min(IF(date 100, q, 4294967296)) as min_q,

Re: revoke all on *.* ??

[EMAIL PROTECTED] (Pawel Eljasz) writes: there is a user with following grants: GRANT USAGE ON *.* TO 'ff'@'localhost' IDENTIFIED BY PASSWORD 'x' is it possible to: revoke all on *.* from $above_user OR revoke usage on *.* from $above_user ? DROP USER [EMAIL PROTECTED]; Simon --

optimizing UNIONs ?

(mysql 5.0.27 on SuSE Linux) I recently thought to use UNIONs to allow me to concatenate vertically some database tables with statements like this create or replace view combo as (select * from nov06) union (select *,ra_corr as ra_cor2,dec_corr as dec_cor2 from jul07) union (select

Re: mysqld-nt Windows service: delay btwn svc running and accepting conx

Hi Les, all, sorry - I attended to other things more than to this thread. Les Schaffer wrote: Joerg Bruehe wrote: I assume Windows reports the status as running when the process(es) got started, but that doesn't necessary imply they have passed their own initialization / startup phase.

Re: mysqld-nt Windows service: delay btwn svc running and accepting conx

Joerg Bruehe wrote: Yes, it does announce. I wrote any external event ... that Windows *would* monitor (emphasis added): Does the Windows ServiceManager really know which file to monitor for which entry to announce the service as running ? see below. in practice we find the service comes

Function Not Working

I have the following function on two servers: CREATE FUNCTION `ProperCase`(cInput TEXT) RETURNS text NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT '' BEGIN Declare cReturn Text; Set cReturn = CONCAT(UPPER(SUBSTRING(cInput,1,1)),LOWER(SUBSTRING(cInput FROM 2)));