Bewilderedly behold this SQL statement:
SELECT * FROM a.b.c;
Nobody can know the meaning of "a.b.c" without knowing the terminology, the context, and the varying intents of various DBMS implementors.

The terminology

It's pretty clear that a.b.c is a name, that is, a unique reference to an SQL object, which in this case is a table.

The name happens to be qualified -- it has three parts separated by periods. A generalist would say that each part is a container, with the first part referring to the outermost container a, which contains b, which contains c. Analogies would be: a directory with a subdirectory and a sub-subdirectory, or an element within a struct within a struct.

That is true but incomplete. Now we fight about what kind of container each
identifier refers to, and what is the maximum number of levels.

What kind of container

The standard suggests that the levels …

It is not new that we can store a JSON content in a normal table text field. This has always been the case in the past. But two key features were missing : filtering based on JSON content attributes and indexing of the JSON content. With MariaDB 10.1 CONNECT storage Engine we offer support for ...continue reading "MariaDB JSON text indexing"

You are working on bootstrap and you want to add datepicker then you have to use bootstrapdatepicker library but if you are new and how to add datepicker in bootstrap then i provide you example of bootstrap datepickerHow to set Datepicker in bootstrap datepicker how to use datepicker in boots

MySQL’s multi-source replication allows you to replicate data from multiple databases into one database in parallel (at the same time). This post will explain and show you how to set up multi-source replication. (WARNING: This is a very long and detailed post.…

Recently i have figured out that we can over-allocate InnoDB buffer pool size as I have already reported:

#79850

So as a result I can start MySQL with 300GB buffer pool size in my 16G laptop.

Config:

innodb_buffer_pool_size=300G
innodb_buffer_pool_instances=64

Started as:

2016-01-05 15:23:58 16211 [Note] InnoDB: Initializing buffer pool, size = 300.0G
2016-01-05 15:24:31 16211 [Note] InnoDB: Completed initialization of buffer pool

If you think that it is not harmful, let’s examine another report:

#79880

With MySQL 5.7.10 in my VM on CentOS 7:

I have:

[root@mysql-57 ~]# free -m
total used free shared buff/cache available
Mem: 3428 …

Hortonworks went to use the lessons to create a fresh database, partnering program, which has become called PostgreSQL. InfiniDB’s paper was likewise read and Hortonworks SQL was designed in the mid-2000s at Uppsala University. In 2010, this job was combined into an independent business. InfiniDB introduced trade management in programs, a notion which was later […]

There is a growing interest in Apache Spark, so I wanted to play with it (especially after Alexander Rubin’s Using Apache Spark post).

To start, I used the recently released Apache Spark 1.6.0 for this experiment, and I will play with “Airlines On-Time Performance” database from
http://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=236&DB_Short_Name=On-Time. You can find the scripts I used here https://github.com/Percona-Lab/ontime-airline-performance. The uncompressed dataset …

In your website you require to set autocomplete user fullname with image generally you use autocomplete with name email message etc text but if you want to add image or your own html code like user html tag in autocomplete then you have to use renderItem in jquery ui how you will create i

In MySQL for Visual Studio version 1.2.4 and earlier, there was an issue, existing only under a specific scenario, which was preventing the plugin to be uninstalled (either using the “Remove” option in the Windows Control Panel/Programs, or the MySQL Installer for Windows) or upgraded to a newer version, causing the uninstall/update action to be rolled back during the process. (For further information about this issue please refer to http://bugs.mysql.com/bug.php?id=71226).

Such scenario can be achieved as follows:

1. First install Visual Studio 2012, or VS 2013 or VS 2015
2. Then, install MySQL for Visual Studio version 1.2.4 or earlier
3. Later, uninstall Visual Studio 2012, or VS2013 or VS2015

With the scenario described above, the uninstall/upgrade process of the MySQL for Visual Studio plugin is …

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.6. This is a maintenance release for 1.3.x. It can be used for production environments.

MySQL for Excel is an application add-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:

• Importing MySQL data into Excel
• Exporting Excel data directly into MySQL to a new or existing table
• Editing MySQL data directly within Excel

MySQL for Excel is installed using the MySQL Installer for …