SQL And Its Sequels

There’s new SQL syntax in MariaDB 12.

To comply with GPL requirements, MySQL and MariaDB include a COPYING or LICENSE file, which has You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Str…

I’ve written an open-source Linux program, pgoptionfiles.c, that tells what a MySQL or MariaDB Connector C library will choose for default option files.

Some Connector/C options can have better explanations than what’s in the MySQL or MariaDB manuals.

The MySQL library is libmysqlclient.so, the MariaDB library is libmariadbclient.so or libmariadb.so.

CREATE PROCEDURE p() BEGIN DECLARE v CHAR CHARACTER SET utf8 DEFAULT ''; SELECT * FROM information_schema.routines WHERE routine_name > v; END; CALL p(); Result: with current MariaDB 11.4 or MySQL 8.3: a result set.

Read The language rules we know – but don’t know we know which says “Adjectives in English absolutely have to be in this order: opinion-size-age-shape-colour-origin-material-purpose Noun.”

Progress Software on 2024-04-19 said more about “considering” an offer for MariaDB plc (the company not the foundation).

Here’s a snippet of what I’d like SHOW ENGINE INNODB STATUS to look like: as opposed to what the server sends: ... -------- FILE I/O -------- Pending flushes (fsync): 0 295 OS file reads, 1 OS file writes, 1 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00…

For example, this works: SHOW AUTHORS GROUP BY `Location` INTO OUTFILE 'tmp.txt'; You’re thinking “Hold it, MySQL and MariaDB won’t allow SHOW (and similar statements like ANALYZE or CHECK or CHECKSUM or DESCRIBE or EXPLAIN or HELP) to work with the same…