开源的 MySQL和Microsoft SQL客户端软件 HeidiSQL
openkk
12年前
HeidiSQL是一个轻量级,基于Windows的 MySQL 和Microsoft SQL数据库管理客户端。它能够让浏览和编辑数据,创建和编辑表格,视图,存储过程,触发器,和计划事件。可以数据和结构导出成SQL文件。
- Connect to multiple servers in one window
- Connect to servers via commandline
- Connect via SSH tunnel, or pass SSL settings
- Create and edit tables, views, stored routines, triggers and scheduled events.
- Generate nice SQL-exports
- Export from one server/database directly to another server/database
- Manage user-privileges
- Import text-files
- Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
- Browse and edit table-data using a comfortable grid
- 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
- Find specific text in all tables of all databases of one server
- Optimize and repair tables in a batch manner
- Launch a parallel mysql.exe command line window using your current connection settings
- And much more