| Version | Change log |
| MySQL 9.0.1 Innova Jul 23, 2024 |
Features Added or Changed in MySQL 9.0: The following features have been added to MySQL 9.0: Saving JSON output from EXPLAIN ANALYZE INTO. As of MySQL 9.0.0, support is now provided for saving JSON output from EXPLAIN ANALYZE into a user variable, using the synatx shown here: EXPLAIN ANALYZE FORMAT=JSON INTO @variable select_stmt The variable can be used subsequently as a JSON argument to any of MySQL's JSON functions (see Section 14.17, “JSON Functions”). The INTO clause is supported only with FORMAT=JSON; FORMAT must be specified explicitly. This form of EXPLAIN ANALYZE also supports an optional FOR SCHEMA or FOR DATABASE clause. Event DDL in prepared statements. Beginning with MySQL 9.0.0, the following statements can be prepared: CREATE EVENT ALTER EVENT DROP EVENT Positional parameters (? placeholders) are not supported for these statements; you must assemble the text of the statement to be prepared from some combination of string literals, system variables, and user variables. One way to accomplish this in a reusable fashion is to assemble the text of, for instance, a CREATE EVENT statement in the body of a stored procedure, passing any variable parts of the statement as IN parameters to the stored procedure; prepare the assembled text with PREPARE; invoke the procedure using the desired parameter values. See PREPARE, EXECUTE, and DEALLOCATE PREPARE Statements, and SQL Syntax Permitted in Prepared Statements, for more information. See Section 15.1.13, “CREATE EVENT Statement”, for an example. Performance Schema system variable tables. MySQL 9.0 add two new tables to the Performance Schema that provide information about server system variables. These tables are listed here: The variables_metadata table provides general information about system variables. This information includes the name, scope, type, range (where applicable), and description of each system variable recognized by the MySQL server. Two of the columns in this table (MIN_VALUE and MAX_ |
| MySQL 8.0.34 Jul 19, 2023 | |
| MySQL 8.0.33 May 2, 2023 |
Total downloads
30
Last month's downloads
1
Last week's downloads
0
... and streamline your workflow? Look no further than MySql WorkSpace, developed by the highly-talented iSlaam Khaleed. A ... getting started with database management, you'll find that MySql WorkSpace offers a range of features and tools ... capabilities, this software has it all. But just because MySql WorkSpace is packed with features doesn't mean it's ...
... full potential of your data integration projects with MySQL SSIS Components by Devart. This powerful toolset seamlessly ... between Microsoft SQL Server Integration Services (SSIS) and MySQL databases, enabling users to effortlessly transfer, transform, and ... more reliable. With a user-friendly interface and robust features, MySQL SSIS Components allow for easy configuration of data ...
... the most efficient database conversion tools - the MySQL to MSSQL Database Conversion Tool by drpudatabase.com. This ... businesses of all sizes transfer their database from MySQL to MSSQL with ease, saving valuable time and ... such as customizable conversion options, support for all MySQL data types, and precise mapping of table structures. ...
