Fedingo

How to Delete All Rows in MySQL Table Except Some

Sometimes you may need to delete all rows in MySQL table except some. Here are the steps to do it.

Sometimes you may get ‘unknown column’ error in MySQL. Here is how to fic unknown column in field list in MySQL.

Often you may need to loop through all rows of table in MySQL. Here is how to do it.

Often you may need to combine columns in MySQL. Here are the steps to do it.

Sometimes you may need to select rows where date matches day in MySQL. Here are the steps to do it.

Sometimes you may need to copy row and insert to same table in MySQL. Here are the steps to do it.

Sometimes you may need to execute SQL files in MySQL. Here is how to run SQL script in MySQL.

Sometimes you may need to find number of columns in MySQL table. Here is how to find number of columns in table in MySQL.

Sometimes you may need to search a specific text in every field of database in MySQL. Here is how to do this.