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

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.comwww.mysql.com or in the web the file mysql-standard-4.0.27-pc-linux-gnu-i686.tar.gz. Also the link HYPERLINK

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

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

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:[EMAIL

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]

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:

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: Thanks for

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

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...,

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 additional

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: