Problems with create procedure

Hi I'm working with mysql 5.0.24a-log trying to create a procedure as is indicated at mysql web page and i get the following error before "delimiter ;" mysql> delimiter // mysql> CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) -> RETURN CONCAT('Hello, ',s,'!'); -> // Query OK, 0 ro

loading scripts to mysql

Hi everybody I'm writing a function script in a flat file using vim, now i would like load it into my sql, there is some command to do it similar to "load data into" to fill tables? thanks -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina

indexing tables using my owns functions

Hi I've created a function that return a float value the code for it is : create function IDR(pin1 varchar(20),pin4 varchar(20),pin6 varchar(20),pin7 varchar(20),pin9 varchar(20),MOL varchar(20)) returns float DETERMINISTIC begin declare output float;

Fwd: loading scripts to mysql

hi, Tanks for your help, finally i found the "source" command. It work like this: mysql> source /Lhome/geruppa/mhc/Pack_Ref_web/prova.sql 2007/11/9, Michael Gargiullo < [EMAIL PROTECTED]>: > > On Fri, 2007-11-09 at 13:22 +0100, Pau Marc Munoz Torres wrote: > &

indexing tables using my owns functions

Hi I've created a function that return a float value the code for it is : create function IDR(pin1 varchar(20),pin4 varchar(20),pin6 varchar(20),pin7 varchar(20),pin9 varchar(20),MOL varchar(20)) returns float DETERMINISTIC begin declare output float;

Re: indexing tables using my owns functions

, as far as i can see, from mysql 5.0 and upper it is possible create index using functions. http://www.faqs.org/docs/ppbook/r24254.htm But i keep having problems with the exemple from the link. Is there any bug in mysql 5.0.24a-log? 2007/11/13, Martijn Tonies <[EMAIL PROTECTED]>: >mysql>

Select form a list

Hi i have list where I would like make a select, this list look like this id Properties Others * 11 sss 22 sss 32 a etc... 42 52 61 72 82 91 .. imagine