November 17, 2015
MySQL 5.7 is GA and has over than 150 new features. One of them is a Native JSON Data Type and JSON Functions: “Allows for efficient and flexible storage, search and manipulation of schema-less data. Enhancements include a new internal binary format, support for easy integration within SQL, and index management on the JSON Documents using generated columns”.
Like this:
Like Loading...
February 28, 2015
Packt Publishing started a Free Learning Campaign by providing a free ebook everyday till 6th March 2015.
Like this:
Like Loading...
Filed under:
MySQL by Olivier DASINI
September 12, 2013
I’m a big fan of the MySQL command line tool ie the default text client modestly named: mysql. I use it everyday because you can do almost everything with it (DML, DDL, DCL, administrative tasks,…).
It has many options including generate xml or html output.
$ mysql –help | grep “\–html”
-H, –html Produce HTML output.
Like this:
Like Loading...
Filed under:
Misc by Olivier DASINI
September 10, 2013
MySQL Tech Day @Paris
We’re happy to announce you that MySQL Tech Day will take place in Paris on Oct 10, 2013 in Oracle main office. It’ll be a full day event giving you an occasion to listen directly from Oracle developers about most of the improvements made recently within MySQL 5.6 and 5.7 development.
Like this:
Like Loading...
August 14, 2012
One of my colleague asked me : « Is an ALTER TABLE with many specifications is faster than 1 ALTER TABLE by specification ? »
The answers seems quite intuitive, anyway figures are better than a long speech…
Context :
MySQL Community Server 5.5.22
InnoDB table with 8 539 238 rows.
17 columns with INT, CHAR, VARCHAR, TEXT, DATETIME, … fields
Like this:
Like Loading...
Filed under:
MySQL by Olivier DASINI