mysql to perfect these function?
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; wangxu [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Friday, January 20, 2006 3:20 PM
Subject:Re: question about CONTAINS SQL
At 8:29 -0500 1/19/06, Rhino wrote
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; wangxu [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Friday, January 20, 2006 2:20 AM
Subject: Re: question about CONTAINS SQL
At 8:29 -0500 1/19/06, Rhino wrote:
I am copying the rest
, January 19, 2006 2:54 AM
Subject: Re: question about CONTAINS SQL
If I create a routine with modification operation and not spectify
characteristic in CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL
DATA.
In the maunal,the default value is CONTAINS SQL if i haven't spectify
a values
, January 19, 2006 9:29 PM
Subject:Re: question about CONTAINS SQL
I am copying the rest of the list with this so that everyone may benefit
from the discussion.
If your routine modifies data, in other words if it does SQL Update, Insert
or Delete but your routine definition says only
any restraints based on them.
Rhino
- Original Message - From: wangxu [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Sent: Thursday, January 19, 2006 2:54 AM
Subject: Re: question about CONTAINS SQL
If I create a routine with modification operation and not
spectify characteristic
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
- 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
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?