MySQL Archives - Page 2 of 9

How to Reset Auto Increment in MySQL

Sometimes you may need to reset auto increment column in MySQL tables. Here is how to reset auto increment in MySQL.

Sometimes you may need to show last queries executed in MySQL. Here are the steps to do so.

Often you may need to convert string to date in MySQL. Here are the steps to do so.

Sometimes you may need to get row count for all tables in MySQL. Here are the steps to do so.

Sometimes you may need to store emoji in MySQL database. Here are the steps to do it.

Sometimes you may need to select nth row in database table. Here are the steps to do it.

Sometimes you may need to search string in multiple tables in MySQL database. Here are the steps to do it.

Sometimes you may need to split MySQL column into two. Here are the steps to do so.

Sometimes you may get the error ‘Can’t Connect to Local MySQL Socket’ error while using MySQL. Here are the steps to fix this error.

MySQL string comparison is case insensitive. Here is how to make case sensitive case string comparison in MySQL.