MySQL Archives - Page 2 of 6

How to Get Character Set of MySQL database or table or column

Often MySQL database administrators need to get character set of MySQL database, table or column. Here is how to do it.

It is important to protect your website from SQL injection attack. Here are the steps to prevent SQL Injection (SQLi).

Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.

Here is the detailed difference between InnoDB vs MyISAM storage engines in MySQL database system.

MySQL supports using single quotes, double quotes and backticks. Here is when to use single quotes, double quotes and backticks in MySQL.

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.

MySQL does not support full outer joins. Here is how to do a full outer join in MySQL.

Row number is very useful in ranking and sorting. Here is how to get row_number 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.