On Wed, May 27, 2009 at 11:24 AM, Cantwell, Bryan
wrote:
> I want to check all my functions and procs into my svn as individual sql
> files. When I use these to create my db, the person doing this may not
> realize the correct order to run these files and not have dependency
> challenges... How
Anakreon Mejdi wrote:
I am trying to create a stored function.
From the docs I saw the code for this function:
CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
DETERMINISTIC
RETURN CONCAT('Hello, ',s,'!');
The version from the docs did not contain the DETERMINISTIC keyword.
I added becaus
Hello.
Sorry. It seems that I've understood your question now. In my opinion,
IGNORE_SPACE not related to CREATE FUNCTION statement, because at:
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
for some cases we have "to use a space between the name and the following
parenthe
't add space between function name and "(".But fact not like this.
Please note example in my reference.
> - Original Message -
> From: "Gleb Paharenko" <[EMAIL PROTECTED]>
> To:
> Sent: Friday, December 30, 2005 2:04 AM
> Subject: Re: cre
Hello.
>From the manual:
ANSI
Equivalent to REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE.
Before MySQL 5.0.3, ANSI also includes ONLY_FULL_GROUP_BY. See Section
1.8.3, âRunning MySQL in ANSI Modeâ.
wangxu wrote:
>I set my sql_mode =
>'STRICT_TRANS_TABLES,ANSI_QUOTES
Matt, Thanks for your reply. It helped me to find out the reason of
problem. Fortunately the reason was so simple:
my /etc/ld.so.conf file contained path /usr/lib/mysql and I thought
/sbin/ldconfig would build the cache so mysql will be able to see
/usr/lib/mysql/ntp2timestamp.so, but it didn't
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 n
Sameh,
Tuesday, July 16, 2002, 9:26:27 AM, you wrote:
SA> Victoria Reznichenko wrote:
SA> >
SA> >SA> Can anybody help me figuring how to control granting users
SA> >SA> permissions to created functions in MySQL like we do for SELECT,
SA> INSERT,
SA> >SA> ...etc or it is not possible and e
Victoria Reznichenko wrote:
>Sameh,
>Sunday, July 14, 2002, 3:09:53 PM, you wrote:
>
>SA> Can anybody help me figuring how to control granting users
>SA> permissions to created functions in MySQL like we do for SELECT,
INSERT,
>SA> ...etc or it is not possible and every one logged in
Sameh,
Sunday, July 14, 2002, 3:09:53 PM, you wrote:
SA> Can anybody help me figuring how to control granting users
SA> permissions to created functions in MySQL like we do for SELECT, INSERT,
SA> ...etc or it is not possible and every one logged in to MySQL could
SA> simply use them like a
ahh sorry for misunderstand. the truth is that i have no idea about the
solution of your problem but i would like to hear from you if you find a
solution.
Sameh Attia wrote:
>
>
> Veysel Harun Sahin wrote:
>
>> http://www.mysql.com/doc/P/r/Privileges.html
>>
>> Sameh Attia wrote:
>>
>>> Hi,
>>
Veysel Harun Sahin wrote:
> http://www.mysql.com/doc/P/r/Privileges.html
>
> Sameh Attia wrote:
>
>> Hi,
>>Can anybody help me figuring how to control granting users
>> permissions to created functions in MySQL like we do for SELECT,
>> INSERT, ...etc or it is not possible and every one l
http://www.mysql.com/doc/P/r/Privileges.html
Sameh Attia wrote:
> Hi,
>Can anybody help me figuring how to control granting users
> permissions to created functions in MySQL like we do for SELECT,
> INSERT, ...etc or it is not possible and every one logged in to MySQL
> could simply use t
Thx a 10e6
Tim.
> -Original Message-
> From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 20, 2001 17:14
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: create function: fails with error 1126
>
>
[snip]
> >
> > I must be o
Tim Wuyts writes:
> Hello,
>
> I tried ldd on the .so file:
> no output! this is very strange.
> I tried to compile this on several other machines, but ldd never gives any
> output.
> If i replace gcc with c++, ldd does show me the shared libraries, but none
> are missing.
> If i try to use the .
Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 18, 2001 17:03
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: create function: fails with error 1126
>
>
> Tim Wuyts writes:
> > All,
> >
> > I'm trying to use the UDF
Tim Wuyts writes:
> All,
>
> I'm trying to use the UDF functionality, but I keep getting the same error
> when I issue the CREATE FUNCTION command.
> This is the error:
>
> mysql> CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "udf_example.so";
> ERROR 1126: Can't open shared library 'udf_exa
17 matches
Mail list logo