MySQL 8.0.21 was released today and one of the many new features
is the JSON_VALUE() function. The main motivation is to
ease index creation values from JSON data but there is more to
it.
JSON_VALUE() finds a specified scalar JSON value in JSON data and
returns it as a SQL value.
Examples
I will use the mysql_x example database data for examples.
So let us start with getting the life expectancy
data.
SELECT JSON_EXTRACT(doc, "$.demographics.LifeExpectancy") AS
raw
FROM countryinfo
LIMIT 4;
+--------------------+
| raw
|
+--------------------+
| 78.4000015258789 |
| 45.900001525878906 |
| 38.29999923706055 |
| 76.0999984741211 |
+--------------------+
That is great information …
Recently the MySQL 8.0 Developer
Certification became available joining the MySQL 8.0 Developer
Certifications. I have recently seen posts on various
social media sites asking what is on the exam, is there an exam
guide, and what do you 'really need to know' to pass the
exam.
Both tests are very tough. Neither is going to
be passed by rote memorization as many of the questions require
analysis of system output before trying to adjust for the desired
result. There are no true or false questions and no
essays. What you will get is a series of questions written
by subject matter experts that range from testing basic
conceptual knowledge to very tough assessments of how to fix
problems. BTW the exam software lets you mark questions for
later review and it does help to bypass the tougher questions for
later review at the end of the test.
Are the question …
Dear MySQL users,
The MySQL developer tools team announces 8.0.21 as our General
Availability
(GA) for MySQL Workbench 8.0.
For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152
The release is now available in source and binary form for a
number of
platforms from our download pages at:
http://dev.mysql.com/downloads/tools/workbench/
Enjoy!
The MySQL Development team is very happy to announce that MySQL 8.0.21 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.21 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
Facebook Twitter LinkedIn
Dear MySQL users,
MySQL Connector/J 8.0.21 is the latest General Availability
release of
the MySQL Connector/J 8.0 series. It is suitable for use
with MySQL
Server versions 8.0, 5.7, and 5.6. It supports the Java
Database
Connectivity (JDBC) 4.2 API, and implements the X DevAPI.
In the documentation for MySQL 8.0.21, we have started
changing the term “master” to “source”, the term “slave” to
“replica”, the term “whitelist” to “allowlist”, and the
term
“blacklist” to “blocklist”. There are currently no changes
to
the product’s syntax, so these terms are still present in
the
documentation where the current code requires their use.
See
the blog post MySQL Terminology Updates
( …
MySQL Server 8.0.21, 5.7.31 and 5.6.49, new versions of the popular Open Source Database Management System, have been released. These releases are recommended for use on production systems. For an overview of what’s new, please see http://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html For information on installing the release on new servers, please see the MySQL installation documentation at […]
Dear MySQL users,
MySQL Connector/Node.js is a new Node.js driver for use with the
X
DevAPI. This release, v8.0.21, is a maintenance release of
the
MySQL Connector/Node.js 8.0 series.
The X DevAPI enables application developers to write code that
combines
the strengths of the relational and document models using a
modern,
NoSQL-like syntax that does not assume previous experience
writing
traditional SQL.
MySQL Connector/Node.js can be downloaded through npm (see
https://www.npmjs.com/package/@mysql/xdevapi for
details) or from
https://dev.mysql.com/downloads/connector/nodejs/.
To learn more about how to write applications using the X DevAPI,
see
…
Dear MySQL users,
MySQL Connector/C++ 8.0.21 is a new release version of the MySQL
Connector/C++ 8.0 series.
Connector/C++ 8.0 can be used to access MySQL implementing Document
Store or in a traditional way, using SQL queries. It allows writing
both C++ and plain C applications using X DevAPI and X DevAPI for C.
It also supports the legacy API of Connector/C++ 1.1 based on JDBC4.
To learn more about how to write applications using X DevAPI, see
“X DevAPI User Guide” at
…
Dear MySQL users,
MySQL Connector/NET 8.0.21 is the latest General Availability
release of
the MySQL Connector/NET 8.0 series. This version supports .NET
Core 3.1
and the X DevAPI, which enables application developers to write
code
that combines the strengths of the relational and document models
using
a modern, NoSQL-like syntax that does not assume previous
experience
writing traditional SQL.
To learn more about how to write applications using the X DevAPI,
see
http://dev.mysql.com/doc/x-devapi-userguide/en/index.html.
For more
information about how the X DevAPI is implemented in
Connector/NET, see
http://dev.mysql.com/doc/dev/connector-net.
NuGet packages provide functionality at a …
Dear MySQL users,
MySQL Connector/ODBC 8.0.21 is a new version in the MySQL
Connector/ODBC
8.0 series, the ODBC driver for the MySQL Server.
The available downloads include both a Unicode driver and an ANSI
driver
based on the same modern codebase. Please select the driver type
you
need based on the type of your application – Unicode or
ANSI.
Server-side prepared statements are enabled by default. It
is suitable
for use with the latest MySQL server version 8.0.
This release of the MySQL ODBC driver is conforming to the ODBC
3.8
specification. It contains implementations of key 3.8
features,
including self-identification as a ODBC 3.8 driver, streaming of
out for
binary types only), and support of the
SQL_ATTR_RESET_CONNECTION
connection attribute (for the Unicode driver only).
The release is now available in …