Can anyone tell me the difference between mysql5.6 and mysql5.7
Mysql – What are the major differences between thesql5.6 and thesql 5.7
MySQL
Related Question
- Mysql – What are the primary differences between NuoDB and MySQL
- Mysql – the difference between optimize table and analyze table in thesql
- Mysql – what is the difference between thesql community server and thesql cluster
- Mysql – the difference between select and fetch time
- Mysql – what’s difference between sql_log_bin and log_bin in MySQL?
- Difference Between Views and Materialized Views in Databases
- Mysql – the difference between Aurora Mysql 5.7.x and Aurora 2.x.x
Best Answer
The release notes for MySQL 5.7 are here.
"What's new in MySQL 5.7" can be found here.
Changes of note:
ONLY_FULL_GROUP_BY is now turned on by default, meaning MySQL will no longer return random data when a user has incorrectly specified columns in the
where
clause, but missed them out of thegroup by
clause.Improvements to online DDL - more
ALTER
operations can be done online without the storage engine having to make a copy of the object in question.InnoDB now supports MySQL-supported spatial data types
InnoDB supports tablespaces
Native JSON support
A new
sys
schema, with summarized performance dataMulti-source replication