List:General Discussion« Previous MessageNext Message »
From:wangxu Date:December 29 2005 3:33am
Subject:create function with space
View as plain text  
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;
END
---------------------------------------------------------------------
There is a space in function name and there is a space between function name and "(".In mysql word,this funciton can't be created.But i created it well.

Why?
Thread
create function with spacewangxu29 Dec
  • Re: create function with spaceGleb Paharenko30 Dec