The SELECT… INTO OUTFILE statement is meant to allow the server host to dump a table to a text file. SELECT… INTO OUTFILE is the
Category: MySQL
Backup a single table – MySQL
It is occasionally necessary to take a table backup before applying data corrections or structural modifications to a table. In the event of a problem,
LOAD DATA INFILE – MySQL – Errors
Rows from a text file are quickly read into a table using the LOAD DATA statement. Depending on whether the LOCAL modifier is specified, the
FULL OUTER JOINS in MySQL?
The SQL FULL OUTER JOIN combines two tables based on a common column and chooses records from both tables that match the values of the
JSON Array to ROWS – MySQL
I recently received a request to divide a JSON data type row value containing an array of numbers into multiple rows. That is one value
INNODB_TEMP_TABLE_INFO
InnoDB temporary tables that are currently active in an InnoDB instance are described in the table INNODB TEMP TABLE INFO. The internal InnoDB temporary tables
Big Data and SQL 