MySQL Archives - Page 3 of 8

How to Find And Replace Text in Entire Table in MySQL

Sometimes you may need to find and replace text in entire table in MySQL. Here are the steps to do so.

Sometimes yo may need to take backup of single table in MySQL. Here are the steps to do so.

Often database developers need to view the indexes on table or database in MySQL. Here are the steps to do so.

Sometimes you may need to replace part of string in update query in MySQL. Here are the steps to do so.

Sometimes you may need to import Excel spreadsheet into MySQL. Here are the steps to do so.

Often database developers need to view MySQL log files. Here is how to view MySQL log files.

MySQLdump command locks tables while taking backup. Here is how to run MySQLdump without locking tables.

Often you may need to import SQL file in MySQL using command line. Here are the steps to do it.

Sometimes you may need to check if row exists in MySQL. Here are the steps to do so.

Sometimes you may need to find when table was last updated in MySQL. Here are the steps to do it.