Make homepage|Add to favorites
 

MYSQL TOOLS
reviews, articles, tips & snippets

 

Select N rows before and after the matching row

 

Select N rows before and after the matching row.

Import, change and format data from CSV file

 

How to import, change and format data from CSV file.

Import data from CSV file

 

How to import data from CSV file.

Export data to CSV file

 

How to export data to CSV file.

Random row selection

 

How to select random record.

Extract many-to-many to many-to-many in one query

 

How to extract many-to-many to many-to-many in one query

Find and remove duplicates

 

How to find and remove duplicates.

Drop multiple tables named with prefix

 

How to drop multiple tables named with prefix (or named with similar pattern).

Delete related records with one query

 

How to delete related records with one query (using ON DELETE CASCADE foreign key).

Delete records from multiple tables with one query

 

How to delete records from multiple tables with one query.