from http://code.google.com/p/heidisql/
HeidiSQL is a lightweight, fast and flexible interface to the popular MySQL-Database. It allows you to browse and edit your databases and tables from an intuitive Windows® interface.
Feature list - very incomplete, not enough space here :)
HeidiSQL is a lightweight, fast and flexible interface to the popular MySQL-Database. It allows you to browse and edit your databases and tables from an intuitive Windows® interface.
Feature list - very incomplete, not enough space here :)
- Generate nice SQL-exports
- Synchronize tables between two databases
- Manage user-privileges
- Import text-files
- Export table-data as CSV, HTML, XML and SQL
- Browse and edit table-data using a comfortable grid
- Create and edit tables, views, stored routines and triggers
- Bulk edit tables (move to db, change engine, collation etc.)
- Batch-insert ascii or binary files into tables
- Write queries with customizable syntax-highlighting and code-completion
- Pretty reformat disordered SQL
- Monitor and kill client-processes
- Connect to servers via commandline
- Find specific text in all tables of all databases of one server
- Optimize and repair tables in a batch manner
- And much more
