Hi All,
I have a problem that I do not quite understand.
I have a table with individuals:
CREATE TABLE `individual` (
`ident` mediumint(8) unsigned NOT NULL auto_increment,
`fid` mediumint(8) unsigned NOT NULL,
`iid` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`ident`),
KEY `fidiid`
then ceiling(x+x*0.15)
when (x=150 AND x200) then (ceiling(x+x*0.10))
when (x=200) then (ceiling(x+x*0.09))
end case;
END$$
DELIMITER ;
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 07, 2006 6:02 PM
To: mysql@lists.mysql.com
Subject: Re: Function
Hello list.
Can somebody tells what's wrong with this fuction?
DELIMITER $$
DROP FUNCTION IF EXISTS `qbit`.`myprice_xondr`$$
CREATE FUNCTION `qbit`.`myprice_xondr`(x float(7,2)) RETURNS float(7,2)
BEGIN
CASE x
WHEN x50 THEN ceiling(x+x*0.25)
when x=50 AND x100 then
Can somebody tells what's wrong with this fuction?
I guess that depends on what it should do, wouldn't it?
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development
On Thursday 07 December 2006 04:57, nikos wrote:
WHEN x50 THEN ceiling(x+x*0.25)
when x=50 AND x100 then ceiling(x+x*0.20)
when x=100 AND x150 then ceiling(x+x*0.15)
when (x=150 AND x200) then (ceiling(x+x*0.10))
when (x=200) then (ceiling(x+x*0.09))
You've declared a return value for
- Original Message -
From: George Chelidze
Sent: Monday, October 27, 2003 9:18 AM
Subject: CREATE FUNCTION problem
Hello, I have created new udf function which converts time from NTP
format to timestamp. I compile it with the following command:
gcc -Wall -shared -o ntp2timestamp.so
Hello, I have created new udf function which converts time from NTP
format to timestamp. I compile it with the following command:
gcc -Wall -shared -o ntp2timestamp.so ntp2timestamp.cc
with no errors.
Then I copy this file to /usr/local/mysql (libmysql* files are located
here and
Hi George,
I think the MySQL-Max RPM is dynamically linked (all -max binaries
actually) if you want to give it a try.
Hope that helps.
Matt
- Original Message -
From: George Chelidze
Sent: Monday, October 27, 2003 9:18 AM
Subject: CREATE FUNCTION problem
Hello, I have created new
PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 11:05 PM
Subject: Re: PASSWORD() function problem
At 17:26 +0800 10/15/03, Manisha Sathe wrote:
Hi,
I inserted one record thr PHPMyAdmin - mem_pass field of member
table set to xyz using function 'PASSWORD'
Then trying
all encryption functions are one way only
Nitin
- Original Message -
From: Manisha Sathe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 6:46 PM
Subject: Re: PASSWORD() function problem
thanks all, it works (i just increase it to 20)
but one more thing, now
-
From: Manisha Sathe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 15:16
Subject: Re: PASSWORD() function problem
thanks all, it works (i just increase it to 20)
but one more thing, now if i want to get this password (e.g for option
forget password), can we
Manisha Sathe [EMAIL PROTECTED] wrote:
thanks all, it works (i just increase it to 20)
Please, don't use PASSWORD() function in your own application, use MD5() or SHA1()
instead.
but one more thing, now if i want to get this password (e.g for option
forget password), can we retrieve, i
Subject: Re: PASSWORD() function problem
all encryption functions are one way only
Nitin
- Original Message -
From: Manisha Sathe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 6:46 PM
Subject: Re: PASSWORD() function problem
thanks all, it works (i just
Thanks all, it helped me a lot
Manisha
- Original Message -
From: Director General: NEFACOMP [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]; Manisha Sathe
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 10:56 PM
Subject: Re: PASSWORD() function problem
Hi,
If I
Hi,
I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz
using function 'PASSWORD'
Then trying to select the same - select * from member where mem_pass = PASSWORD('xyz')
- then it is not getting selected
I do not know why I am not getting the result. please help
On Wed, 15 Oct 2003 17:26:23 +0800
Manisha Sathe [EMAIL PROTECTED] wrote:
Hi,
I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz
using function 'PASSWORD'
Then trying to select the same - select * from member where mem_pass =
PASSWORD('xyz') - then it is
At 17:26 +0800 10/15/03, Manisha Sathe wrote:
Hi,
I inserted one record thr PHPMyAdmin - mem_pass field of member
table set to xyz using function 'PASSWORD'
Then trying to select the same - select * from member where mem_pass
= PASSWORD('xyz') - then it is not getting selected
I do not know
3.23.35-log reports it correctly.
Cal
http://www.calevans.com
-Original Message-
From: Gordon Werner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 12:01 PM
To: [EMAIL PROTECTED]
Subject: mySQL INSTR function problem
Hi there ...
I am running mySQL Ver. 9.33 Distrib
18 matches
Mail list logo