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
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 =
function name and (.But fact not like this.
Please note example in my reference.
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, December 30, 2005 2:04 AM
Subject: Re: create function with space
Hello.
From the manual
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;