It is important to protect your website from SQL injection attack. Here are the steps to prevent SQL Injection (SQLi).
How to Prevent SQL Injection Attack
MySQL
How to MySQLDump Only Specific Tables
Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.
Difference Between InnoDB vs MyISAM
Single quotes, Double quotes and Backticks in MySQL
MySQL supports using single quotes, double quotes and backticks. Here is when to use single quotes, double quotes and backticks in MySQL.
Inner join vs Outer join in SQL
Inner join and outer join are useful to join database tables in SQL. Here is the difference between inner join and outer join in SQL.
How To Do Full Outer Join in MySQL
How To Get row_number in MySQL
How to Get Data For Every Hour in MySQL
Sometimes you may need to get data for every hour, or retrieve hourly data in MySQL. Here is how to get data for every hour in MySQL.
How To Get Last 1 Hour Data in MySQL
It is useful to fetch last 1 hour rows or retrieve last 1 hour records. Here is how to get last 1 hour data in MySQL.
How to Show Rows Not Present in Another Table in MySQL
Sometimes you may need to find rows not present in another table or select rows not present in another table. Here is how to show rows not present in another table in MySQL.