MySQL Archives - Page 9 of 14

How to Do Regular Expression Replace in MySQL

Sometimes you may need to replace multiple strings & patterns in column in MySQL. Here is how to do regular expression replace in MySQL.

Sometimes you may need to extract number from string or numerical value from string in MySQL. Here is how to get digits from string in MySQL.

Sometimes you may need to update row based on previous row 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.

Sometimes you may need to take backup of MySQL database in Python. Here are the steps to do it.

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 change default MySQL data directory. Here are the steps to do it.

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