MySQL Magazine - Winter Issue released

I just posted the latest edition of MySQL Magazine. It is available for free download from http://www.mysqlzine.net. Take a look! Keith -- B. Keith Murphy Paragon Consulting Services http://www.paragon-cs.com 850-637-3877 -- MySQL General Mailing List For list archives: http://lists.mysql

Re: help with count in grouped query

On Jan 10, 2008 5:40 PM, Eben <[EMAIL PROTECTED]> wrote: > I want to be able to do count of the total records brought back by this > query... but since I am using the group by I can't use COUNT() in the > desired way. Assuming what you want is all the data from your current query plus an additiona

help with count in grouped query

I have this query: SELECT table.id,table.field_1,table.field_2,COUNT(table.field_1) as total FROM table WHERE MATCH table.field_1 AGAINST ('some text') GROUP BY table.field_1,table.field_2 which returns aggregate results like: 1, data..., data..., 3 2, data..., data..., 1 3, data..., data..., 5

Re: Securing the Data

On Fri, Jan 11, 2008 at 02:01:37AM +0530, Sujatha S wrote: > Thanks for the update. Is there any method to encrypt the data on mysql? Of course you can do that. You only need to find trustworthy developers and let them implement that. Why do you let them work with production data in the first pla

Re: Securing the Data

Thanks Jimmy.. i have to read it!.. Regards, Suja On 1/11/08, Jimmy Guerrero <[EMAIL PROTECTED]> wrote: > > Hello, > > http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html > > discusses some available encrypt and decrypt functions native to MySQL. > > -- Jimmy > > Sujatha S wrote: >

RE: Securing the Data

Hmmm most likely developers will have a way to get that "pass_str" since they are the Developers.. :) -Original Message- From: Jimmy Guerrero [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 3:35 PM To: Sujatha S Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: Re: Securi

Re: Securing the Data

Hello, http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html discusses some available encrypt and decrypt functions native to MySQL. -- Jimmy Sujatha S wrote: Thanks for the update. Is there any method to encrypt the data on mysql? Regards, Suja On 1/11/08, [EMAIL PROTECTED] <[EM

Re: Securing the Data

Thanks for the update. Is there any method to encrypt the data on mysql? Regards, Suja On 1/11/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > You can limit access to tables in a database using a specific login.. > > Read on GRANT > > > > -Original Message- > From: Sujatha S [mailto:

RE: Securing the Data

You can limit access to tables in a database using a specific login.. Read on GRANT -Original Message- From: Sujatha S [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 3:06 PM To: mysql@lists.mysql.com Subject: Securing the Data Hello, Is it possible to encrypt data on mys

Securing the Data

Hello, Is it possible to encrypt data on mysql database. I have the following requirement. We have a development team, which will be involved in payroll system. They will update the salary information of all the employees in mysql database. Due to this the members in development team

Download MySQL 4.0.30

Hi. I has a Linux server with MySQL 4.0.27 and I want to upgrade to 4.0.30 but I couldn't find in HYPERLINK "http://www.mysql.com"www.mysql.com or in the web the file mysql-standard-4.0.27-pc-linux-gnu-i686.tar.gz. Also the link HYPERLINK "http://downloads.mysql.com/archives.php"http://downloads.

Re: why in procedure truncate table do not reset auto_increment?

x schrieb: thanks may you point out which chapter says? From manual I get the following answer agaist to my result(my server version 5.0.45), For |InnoDB| before version 5.0.3, |TRUNCATE TABLE| is mapped to |DELETE|, so there is no difference. Starting with MySQL 5.0.3, fast |TRUNCATE TABLE|