Yes,I already read this section. But, maybe there are haven't relation to my question. Are the effect of setting IGNORE_SPACE in sql mode allowing add space between function name and "("? If my attitude is right,then if i haven't setting IGNORE_SPACE in sql mode,I shouldn'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: <mysql@lists.mysql.com> > Sent: Friday, December 30, 2005 2:04 AM > Subject: Re: create function with space > > > > 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,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. > > > > > > -- > > For technical support contracts, goto https://order.mysql.com/?ref=ensita > > This email is sponsored by Ensita.NET http://www.ensita.net/ > > __ ___ ___ ____ __ > > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > > <___/ www.mysql.com > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > >