If you are writing something that does INSERT, UPDATE, or DELETE, you need
to use the MODIFIES SQL DATA option.
Rhino
----- Original Message -----
From: "wangxu" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
Sent: Wednesday, January 18, 2006 3:05 AM
Subject: Re: question about "CONTAINS SQL"
But what is INSERT OR UPDATE need?
----- Original Message -----
From: "Rhino" <[EMAIL PROTECTED]>
To: "wangxu" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
Sent: Tuesday, January 17, 2006 9:49 PM
Re: question about "CONTAINS SQL"
> ----- Original Message -----
> From: "wangxu" <[EMAIL PROTECTED]>
> To: <mysql@lists.mysql.com>
> Sent: Tuesday, January 17, 2006 12:35 AM
> Subject: question about "CONTAINS SQL"
>
>
> >I notice there are one section in the manual:
> >
> > CONTAINS SQL indicates that the routine does not contain statements
> > that
> > read or write data.
> >
> > And that the option is default.
> >
> > It's true?
> >
> > If i wouldn't do read or write in routine.What can i do yet?
> >
>
> Commands like GRANT or REVOKE or CREATE TABLE don't read or write data
> within tables but they involve SQL so commands like this need CONTAINS
> SQL,
> rather than the NO SQL, READS SQL DATA or MODIFIES SQL DATA options.
>
> Rhino
>
>
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date:
> 16/01/2006
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.20/233 - Release Date: 18/01/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.20/233 - Release Date: 18/01/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
