Re: question about "sql security"

2006-01-11 Thread wangxu
- Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Wednesday, January 04, 2006 5:22 PM Subject: Re: question about "sql security" > Hello. > > In my opinion, a good description can be found here: > http://dev.mysql.com/tec

Re: question about "sql security"

2006-01-04 Thread Peter Brawley
>I refer a question about "sql security" option of create procedure syntax >at 2005-12. But i can't quite understood with that answer. >Can you give me a example to describe the effect of set "sql security" >option ? CREATE PROCEDURE ... SQL SECURITY INVOK

Re: question about "sql security"

2006-01-04 Thread Gleb Paharenko
Hello. In my opinion, a good description can be found here: http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html "wangxu" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET

question about "sql security"

2006-01-03 Thread wangxu
I refer a question about "sql security" option of create procedure syntax at 2005-12. But i can't quite understood with that answer. Can you give me a example to describe the effect of set "sql security" option ?

Re: question about sql mode = ansi

2005-12-29 Thread Paul DuBois
At 11:50 +0800 12/30/05, wangxu wrote: AS 1.7.3. Running MySQL in ANSI Mode explain: -- Running the server in ANSI mode is the same as starting it with these options (specify the --sql_mode value on a single line): --transacti

question about sql mode = ansi

2005-12-29 Thread wangxu
AS 1.7.3. Running MySQL in ANSI Mode explain: -- Running the server in ANSI mode is the same as starting it with these options (specify the --sql_mode value on a single line): --transaction-isolation=SERIALIZABLE --sql-mode=REAL_AS_

Re: Question about SQL statements......

2004-08-25 Thread David Souza
You rock!! Worked perfectly On Aug 25, 2004, at 4:31 PM, Rhino wrote: - Original Message - From: "David Souza" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 25, 2004 7:18 PM Subject: Question about SQL statements.. So I have all of th

Re: Question about SQL statements......

2004-08-25 Thread Rhino
- Original Message - From: "David Souza" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 25, 2004 7:18 PM Subject: Question about SQL statements.. > So I have all of this years apache access logs in a huge DB table, most > of

Question about SQL statements......

2004-08-25 Thread David Souza
So I have all of this years apache access logs in a huge DB table, most of what I wanted to get out is working fine, but I am trying to get top 10 requests (hits) by day inside a certain section of the hierarchy, but I can't seem to get the correct results. I have been trying many different

Question about SQL...

2002-02-22 Thread Egor Egorov
Guillaume, Friday, February 22, 2002, 1:47:09 PM, you wrote: GB> Hi all, GB> i'm a newbie on this Mailing-list and i'm French. GB> So, sorry for my POOR english... GB> I try to execute an SQL Command but i have a syntax error : GB> SELECT Id_Game GB> FROM game GB> WHERE Id_Game NOT IN ( GB> S

RE: Question about SQL...

2002-02-22 Thread Xavier Prélat [webcentric]
: vendredi 22 février 2002 12:47 À : [EMAIL PROTECTED] Objet : Question about SQL... Hi all, i'm a newbie on this Mailing-list and i'm French. So, sorry for my POOR english... I try to execute an SQL Command but i have a syntax error : SELECT Id_Game FROM game WHERE Id_Game NOT IN (

Re: Question about SQL...

2002-02-22 Thread Wolfgang Pichler
Hi Subselects doesn't work at time. Am Fre, 2002-02-22 um 12.47 schrieb Guillaume BABIK: > Hi all, > i'm a newbie on this Mailing-list and i'm French. > So, sorry for my POOR english... > I try to execute an SQL Command but i have a syntax error : > SELECT Id_Game > FROM game > WHERE Id_Gam

Question about SQL...

2002-02-22 Thread Guillaume BABIK
Hi all, i'm a newbie on this Mailing-list and i'm French. So, sorry for my POOR english... I try to execute an SQL Command but i have a syntax error : SELECT Id_Game FROM game WHERE Id_Game NOT IN ( SELECT Id_Game FROM member_game a WHERE Id_Member = 4 ) I don't know waht happend.. Help me..