MySQL Archives - Page 5 of 8

How to Set Query Timeout in MySQL

Sometimes you may need to set query timeout in MySQL. Here are the steps to do it.

Sometimes you may need to copy column to another column in MySQL. Here are the steps to do it.

Sometimes you may need to unlock user account in MySQL. Here are the steps to do it.

Sometimes you may need to lock user account in MySQL. Here are the steps to lock user accounts in MySQL.

Clustered Indexes allow faster lookups and improve query performance. Here are more details about clustered indexes in MySQL.

MySQL AND operator is useful to combine variables, conditions and column values in MySQL. Here are different MySQL AND operator examples.

Sometimes you may need to run MySQL queries from terminal or shell script. Here is how to run MySQL query from command line.

Sometimes you may need to extract database from MySQL dump file. Here are the steps to restore or import single database in MySQL.

MySQL supports InnoDB and MyISAM. Here is how to change table engine from InnoDB to MyISAM.

MySQL Datetime & Timestamp are two useful data types. Here are the key differences between the two data types in MySQL.