This is a 3 part blog series:
Have you ever encountered situations where you want to grant a user access to all databases except a few databases ? …
This is a 3 part blog series:
To modify users, you must have the CREATE USER privilege or the UPDATE privilege on the mysql schema.…
This is a 3 part blog series:
You can now grant CREATE USER so that your web apps would be able to use multiple accounts without you risking the end user hijacking the database by changing your root credentials for example. …
As of 8.0.16, the mysql_upgrade binary is deprecated, but its functionality is moved into the server. Let’s call this functionality the “server upgrade”. This is added alongside the Data Dictionary upgrade (DD Upgrade), which is a process to update the data dictionary table definitions.…
The MySQL Development team is proud to announce a new version of the MySQL Shell which includes the following features:
The MySQL Development Team is very happy to announce a new 8.0 GA Maintenance Release of InnoDB Cluster – 8.0.16!
In addition to important bug fixes, 8.0.16 brings very useful new features!
This blog post will cover MySQL Shell and the AdminAPI, for detailed information of what’s new in MySQL Router stay tuned for an upcoming blog post!…
MySQL 8.0.16 introduces the SQL CHECK constraint feature. This is one of the most requested and long awaited features for MySQL. This post describes the details of the feature. Let’s get started!
The CHECK constraint is a type of integrity constraint in SQL.…
The MySQL Development team is very happy to announce that MySQL 8.0.16 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.16 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
In MySQL, historically GROUP BY was used to provide sorting as well. If a query specified GROUP BY, the result was sorted as if ORDER BY was present in the query.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
mysql-5.7> CREATE TABLE t (id INTEGER, cnt INTEGER); Query OK, 0 rows affected (0.03 sec) mysql-5.7> INSERT INTO t VALUES (4,1),(3,2),(1,4),(2,2),(1,1),(1,5),(2,6),(2,1),(1,3),(3,4),(4,5),(3,6); Query OK, 12 rows affected (0.02 sec) Records: 12 Duplicates: 0 Warnings: 0 mysql-5.7> SELECT id, SUM(cnt) FROM t GROUP BY id; +------+----------+ | id | SUM(cnt) | +------+----------+ | 1 | 13 | | 2 | 9 | | 3 | 12 | | 4 | 6 | +------+----------+ 4 rows in set (0.00 sec) |
MySQL here implicitly sorts the results from GROUP BY (i.e.…