If you experience the error: There was an error filtering log events The specified log group does not exist, checking the parameter group may be
MySQL JOINs – USING vs ON
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,
Run a shell script in EC2
It’s really simple to execute a batch file in Windows by just invoking the script in PowerShell or by double-clicking. Similarly, you must specify the
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,
Dynamic SQL – Export Data
As specified in the previous post, the method we use to write SQL queries so that they are dynamically built alongside application actions is known
Big Data & SQL 