IF and CASE

2013-02-05 Thread hsv
It is my impression that when their functions are equivalent, IF takes more time than CASE. Comment? Do they always evaluate all their arguments? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

MySQL Community Server 5.1.68 has been released

2013-02-05 Thread Hery Ramilison
Dear MySQL users, MySQL Server 5.1.68, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.68 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see

MySQL Community Server 5.5.30 has been released

2013-02-05 Thread Sunanda Menon
Dear MySQL users, MySQL 5.5.30 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.30 is recommended for use on production systems. MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the MySQL

MySQL Connector/ODBC 5.1.12 has been released

2013-02-05 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.1.12, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the latest release of the 5.1 series and is suitable for use with any MySQL version since 4.1 (It will not work with 4.0 or earlier

MySQL Connector/C++ 1.1.2 has been released

2013-02-05 Thread Kent Boortz
Dear MySQL Users, A new GA (general availability) version of MySQL Connector/C++ has been made available: MySQL Connector/C++ 1.1.2 GA. The MySQL Connector/C++ provides a C++ API for connecting client applications to the MySQL Server 5.1 or newer. You can download the production release at:

MySQL Connector/ODBC 5.2.4 has been released

2013-02-05 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.2.4, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select driver type you need based on the

MySQL Community Server 5.6.10 (GA) has been released

2013-02-05 Thread Bjorn Munch
Dear MySQL users, MySQL Server 5.6.10 (GA) is a new version of the world's most popular open source database. This is the first official release of MySQL 5.6. The new features in this release are now deemed to be of Release quality. Note that 5.6.10 includes all features in MySQL 5.5 and

SELECT subquery problem

2013-02-05 Thread cl
De-lurking here. I am trying to figure out how to return results from a query. What I need to do is to return 4 columns from a database. This is easy: SELECT last_name, first_name, phone, email FROM `mydatabasetable` WHERE `current_member` = Y AND `pub_name` = Y ORDER BY last_name ASC This

Re: SELECT subquery problem

2013-02-05 Thread Andrew Moore
Try using a CASE construct in the select. Should work for this. A On Tue, Feb 5, 2013 at 3:25 PM, Stefan Kuhn stef...@web.de wrote: You cannot do this. A sql result alwas has the same number of columns in each row. You could have null or in the column, though. This could be done via the

RE: IF and CASE

2013-02-05 Thread Rick James
As a Rule of Thumb, function evaluation time is not significant to the overall time for running a query. (I see IF and CASE as 'functions' for this discussion.) Do you have evidence that says that IF is slower? Perhaps using BENCHMARK()? -Original Message- From: h...@tbbs.net

Aw: SELECT subquery problem

2013-02-05 Thread Stefan Kuhn
You cannot do this. A sql result alwas has the same number of columns in each row. You could have null or in the column, though. This could be done via the if(,,)-statement of mysql or by using a union and two selects, one for pub_email=n and the other for the rest. Gesendet: Dienstag, 05.

Re: file level encryption on mysql

2013-02-05 Thread Mike Franon
Thanks! I tried all these methods and you are right this is not going to work for us. I am not a developer, does anyone have any good links or reference to the best way I can share with my developers on best way to encrypt and decrypt personal user info. We do not store credit cards, but want

Re: file level encryption on mysql

2013-02-05 Thread Reindl Harald
you have to encrypt them in the application and make the key stored as safe as possible, however for a full intrution there is no way to protect data which can not be only hashed somewhere you need the information how to encrypt them Am 05.02.2013 15:18, schrieb Mike Franon: I tried all these

Re: file level encryption on mysql

2013-02-05 Thread Mike Franon
Which is the best way ? I see you can do it from PHP itself http://coding.smashingmagazine.com/2012/05/20/replicating-mysql-aes-encryption-methods-with-php/ or can use mysql AES? http://security.stackexchange.com/questions/16473/how-do-i-protect-user-data-at-rest From what I understand we

RE: IF and CASE

2013-02-05 Thread hsv
2013/02/05 17:06 +, Rick James As a Rule of Thumb, function evaluation time is not significant to the overall time for running a query. (I see IF and CASE as 'functions' for this discussion.) Do you have evidence that says that IF is slower? Perhaps using BENCHMARK()? Not BENCHMARK: I

RE: file level encryption on mysql

2013-02-05 Thread Rick James
AES encryption is weak because it is too easy for the hacker to get the passphrase. If you can somehow hide the passphrase behind 'root', you can at least prevent a non-sudo user from seeing the data. Your web server starts as root, then degrades itself before taking requests. If it can grab