Both USING and ON will work in the same way in JOINS. It combines the two tables and returns the matched records from both. However,
Category: MySQL
MySQL – OUTFILE – Table Data to File
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
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
Big Data & SQL 