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| is available. However, the operation is still mapped to |DELETE| if there are foreign key constraints that reference the table. (When fast truncate is used, it resets any |AUTO_INCREMENT| counter. From MySQL 5.0.13 on, the |AUTO_INCREMENT| counter is reset by |TRUNCATE TABLE|, regardless of whether there is a foreign key constraint.) The table handler does not remember the last used |AUTO_INCREMENT| value, but starts counting from the beginning. This is true even for |MyISAM| and |InnoDB|, which normally do not reuse sequence values. See: http://dev.mysql.com/doc/refman/5.0/en/truncate.html http://dev.mysql.com/doc/refman/5.1/en/truncate.html oh sorry, yes, i was confused, somehow i mixed some old behavior and InnoDB behavior ... Martijn Tonies, sorry too -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.mysql.com/archives .php doesn't work. Could somebody provide a link to this file? Thanks in advance. Iago. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.0/1216 - Release Date: 09/01/2008 10:16
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 have the rights to access the payroll table, were they can see the salary of others employee and many more information of employee. My question is , do we have any secure method to protect the data. Like storing the data on encrypted format in mysql database. Also, do we have any other possible methods to restrict the development team from access on the data's Regards, Suja
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 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 have the rights to access the payroll table, were they can see the salary of others employee and many more information of employee. My question is , do we have any secure method to protect the data. Like storing the data on encrypted format in mysql database. Also, do we have any other possible methods to restrict the development team from access on the data's Regards, Suja This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 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 have the rights to > access the payroll table, were they can see the salary of others > employee > and many more information of employee. > > > > My question is , do we have any secure method to protect the data. Like > storing the data on encrypted format in mysql database. > > Also, do we have any other possible methods to restrict the development > team > from access on the data's > > > > Regards, > > Suja > > > > This message and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom it is > addressed. It may contain sensitive and private proprietary or legally > privileged information. No confidentiality or privilege is waived or > lost by any mistransmission. If you are not the intended recipient, > please immediately delete it and all copies of it from your system, > destroy any hard copies of it and notify the sender. You must not, > directly or indirectly, use, disclose, distribute, print, or copy any > part of this message if you are not the intended recipient. > FXDirectDealer, LLC reserves the right to monitor all e-mail > communications through its networks. Any views expressed in this > message are those of the individual sender, except where the > message states otherwise and the sender is authorized to state them. > > Unless otherwise stated, any pricing information given in this message > is indicative only, is subject to change and does not constitute an > offer to deal at any price quoted. Any reference to the terms of > executed transactions should be treated as preliminary only and subject > to our formal confirmation. FXDirectDealer, LLC is not responsible for any > recommendation, solicitation, offer or agreement or any information > about any transaction, customer account or account activity contained in > this communication. > >
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] <[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 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 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 have the rights to access the payroll table, were they can see the salary of others employee and many more information of employee. My question is , do we have any secure method to protect the data. Like storing the data on encrypted format in mysql database. Also, do we have any other possible methods to restrict the development team from access on the data's Regards, Suja This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[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: 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] <[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 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 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 have the rights to >> access the payroll table, were they can see the salary of others >> employee >> and many more information of employee. >> >> >> >> My question is , do we have any secure method to protect the data. Like >> storing the data on encrypted format in mysql database. >> >> Also, do we have any other possible methods to restrict the development >> team >> from access on the data's >> >> >> >> Regards, >> >> Suja >> >> >> >> This message and any files transmitted with it are confidential and >> intended solely for the use of the individual or entity to whom it is >> addressed. It may contain sensitive and private proprietary or legally >> privileged information. No confidentiality or privilege is waived or >> lost by any mistransmission. If you are not the intended recipient, >> please immediately delete it and all copies of it from your system, >> destroy any hard copies of it and notify the sender. You must not, >> directly or indirectly, use, disclose, distribute, print, or copy any >> part of this message if you are not the intended recipient. >> FXDirectDealer, LLC reserves the right to monitor all e-mail >> communications through its networks. Any views expressed in this >> message are those of the individual sender, except where the >> message states otherwise and the sender is authorized to state them. >> >> Unless otherwise stated, any pricing information given in this message >> is indicative only, is subject to change and does not constitute an >> offer to deal at any price quoted. Any reference to the terms of >> executed transactions should be treated as preliminary only and subject >> to our formal confirmation. FXDirectDealer, LLC is not responsible for any >> recommendation, solicitation, offer or agreement or any information >> about any transaction, customer account or account activity contained in >> this communication. >> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 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 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 have the rights > to > >> access the payroll table, were they can see the salary of others > >> employee > >> and many more information of employee. > >> > >> > >> > >> My question is , do we have any secure method to protect the data. Like > >> storing the data on encrypted format in mysql database. > >> > >> Also, do we have any other possible methods to restrict the development > >> team > >> from access on the data's > >> > >> > >> > >> Regards, > >> > >> Suja > >> > >> > >> > > >> This message and any files transmitted with it are confidential and > >> intended solely for the use of the individual or entity to whom it is > >> addressed. It may contain sensitive and private proprietary or legally > >> privileged information. No confidentiality or privilege is waived or > >> lost by any mistransmission. If you are not the intended recipient, > >> please immediately delete it and all copies of it from your system, > >> destroy any hard copies of it and notify the sender. You must not, > >> directly or indirectly, use, disclose, distribute, print, or copy any > >> part of this message if you are not the intended recipient. > >> FXDirectDealer, LLC reserves the right to monitor all e-mail > >> communications through its networks. Any views expressed in this > >> message are those of the individual sender, except where the > >> message states otherwise and the sender is authorized to state them. > >> > >> Unless otherwise stated, any pricing information given in this message > >> is indicative only, is subject to change and does not constitute an > >> offer to deal at any price quoted. Any reference to the terms of > >> executed transactions should be treated as preliminary only and subject > >> to our formal confirmation. FXDirectDealer, LLC is not responsible for > any > >> recommendation, solicitation, offer or agreement or any information > >> about any transaction, customer account or account activity contained > in > >> this communication. > >> > >> > > >
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 place? Make a complete dump, set up a development database and do something like update salaries set salary = floor(100 + 100 * rand()) Regards, Matthias Witte -- [netzquadrat] GmbH www.billiger-telefonieren.de Gladbacher Straße 74 www.billiger-surfen.de 40219 Düsseldorf www.sms.de Tel/Fax: +49 211 30 20 33 18/22 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 etc... 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. So let's say this query returns 15 records, how might I refactor this query so I can just get back one record showing that it returned 15 results? Any suggestions or pointers are appreciated thanks, Eben -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 row showing a full count, you can use WITH ROLLUP to get it. Or just do a separate COUNT query without the GROUP BY. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]