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
I set my sql_mode =
'STRICT_TRANS_TABLES,ANSI_QUOTES,ERROR_FOR_DIVISION_BY_ZERO'.
Note,IGNORE_SPACE not include sql mode.
But i still execute statement as follow :
CREATE FUNCTION "wangxu"."user " () RETURNS int(11)
BEGIN
return 1;
