MySQL Archives - Page 2 of 6

How to Reset Auto Increment in MySQL

Sometimes database developers need to reset auto increment column in MySQL. Here are different ways to set the auto increment value.

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.