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))); RET

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 co

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.

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: 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]; Simo

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, max(IF

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 e-

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 *.* from

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 >> an

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 fr

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