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
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
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
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
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:
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
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
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
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
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
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.
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
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
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
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
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
16 matches
Mail list logo