Updated: 04 October 2024
Create a gzip file of backup.sql and keep the original file
gzip --keep backup.sqlDecompress an archive
gzip -d backup.sql.gzsql
MySQL joins
Updated: 19 April 2023
Equivalent statements
LEFT JOIN LEFT OUTER JOIN
RIGHT JOIN RIGHT OUTER JOIN
FULL JOIN FULL OUTER JOIN
INNER JOIN JOIN