No Image

Using the aggregate functions ANY, SOME, EVERY with MySQL

2015-12-15 KENNETH 0

If you have used SQL a bit, you are certainly familiar with so-called set functions or aggregate functions COUNT, SUM, AVG, described in the manual. For example, let’s say that I am the owner of a shop and I keep track of daily sales in this table: create table sales (month int, day int, amount int); The first column is the number of the month, between 1 and 12, the second column is the number of the day in the month, between 1 and 31, and the third column is how much we sold on that date.… Source: mysqlserverteam.com

No Image

Deprecating the mysql_config –libs_r option

2015-12-10 KENNETH 0

As Norvald wrote in his recent post: A long time ago, libmysqlclient came in two versions: one that was thread safe and one that wasn’t. But that was a long time ago. Since MySQL 5.5, the thread safe libmysqlclient_r library has just been a symlink to the libmysqlclient library, which has been thread safe at least since then. … Source: mysqlserverteam.com

No Image

MySQL 5.7: Improved Performance of Queries with Derived Tables

2015-12-08 KENNETH 0

In a recent blog post my colleague Roy presented his work for MySQL 5.7 that makes the query optimizer merge sub-queries in the  FROM clause (so-called derived tables) with the outer query.  I will in this blog post show an example of how this work improves the performance of a MySQL query.… Source: mysqlserverteam.com

WordPress 4.4 “Clifford”

2015-12-08 KENNETH 0

Version 4.4 of WordPress, named “Clifford” in honor of jazz trumpeter Clifford Brown, is available for download or update in your WordPress dashboard. New features in 4.4 make your site more connected and responsive. Clifford also introduces a new default theme, Twenty Sixteen. Introducing Twenty Sixteen Our newest default theme, Twenty Sixteen, is a modern take on a classic blog design. Twenty Sixteen was built to look great on any device. A fluid grid design, flexible header, fun color schemes, and more, will all make your content shine. Responsive Images WordPress now takes a smarter approach to displaying appropriate image sizes on any device, ensuring a perfect fit every time. You don’t need to do anything to your theme, it just works. Embed Everything New Embeds Feature in WordPress 4.4 Now you can embed your posts on other WordPress sites. Simply drop [ more… ]