MySQL Archives - Fedingo

MySQL INSERT or UPDATE if exists

Sometimes you may need to insert or update data in MySQL table. Here are the steps to use MySQL Insert or Update.

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.