Make homepage|Add to favorites
 

MYSQL TOOLS
reviews, articles, tips & snippets

 

Select N rows before and after the matching row

Author: rootsql on 16-11-2011, 22:35

 

Select N rows before and after the matching row.

Import, change and format data from CSV file

Author: rootsql on 15-11-2011, 21:48

 

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

Import data from CSV file

Author: rootsql on 15-11-2011, 21:46

 

How to import data from CSV file.

Export data to CSV file

Author: rootsql on 15-11-2011, 21:44

 

How to export data to CSV file.

Random row selection

Author: rootsql on 11-11-2011, 22:20

 

How to select random record.

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

Author: rootsql on 10-11-2011, 22:09

 

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

Profiler for MySQL - Jet Profiler

Author: Dicentis on 8-11-2011, 17:17

 

is a real-time query performance and diagnostics tool for the MySQL database server. It's core features:

  • Query, table and user performance
  • Graphical visualisation
  • Low overhead
  • User friendly

Find and remove duplicates

Author: rootsql on 7-11-2011, 22:31

 

How to find and remove duplicates.

Drop multiple tables named with prefix

Author: rootsql on 7-11-2011, 22:28

 

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

Delete related records with one query

Author: rootsql on 7-11-2011, 22:26

 

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