Screenshots and features of HeidiSQL
Connection
The very first dialog which asks for hostname and credentials. The list of wanted databases can be limited and sorted alphabetically. |
Usermanager
Administer MySQL accounts as easily as a toy. A pulldown showing assigned database objects reveals everything. |
Host Variables
The list of server variables. Most of them are editable by doubleclick. Filterable. |
Variable Editor
Editable server variables, either for session or global scope. |
Host Processlist
The list of currently running processes. Used to analyze executed SQL and to kill bad processes. |
Host Commandstats
Graphical statistics on the amount of all different SQL commands. |
Database
Details about tables and views. Switchable column headers. Used to rename, delete, empty and modify tables. |
Create Db
Create, modify databases and assign a character set + collation. |
Create Table
Visually generate and run a CREATE TABLE statement. |
View Editor
Create and mofify VIEWs on newer MySQL servers. |
Copy Table
Create exact copies of an existing table, within the same database or in another one. |
Table
Field details of the selected table. Colorized bullets tell about indexes. |
Field Editor
Modify or add fields, set datatype, default value and various flags. |
Index Editor
Edit and create primary, unique, fulltext and "normal" indexes, assign fields to them. |
Data
Table contents editable in a grid. Switchable columns and sorting orders. Various filtering mechanisms. |
Query
SQL query editing: Customizable syntax highlighting, snippet files, completion proposal pulldown and editable results. |
Export Sql
Pump database structures and data into a single dump file, one file per table or directly to another host. |
Export Textfile
Save the result of any data grid to CSV, HTML and XML files. |
Import Textfile
Import CSV or delimited files produced by spread sheet applications directly into a MySQL table. |
Insert Files
Read lots of files per batch into BLOBs, using macros for neighbour fields. Binary safe. |
Maintenance
Optimize, check, analyze and repair tables by a few mouseclicks. |
Send any list of tables, columns, variables etc. to your printer. Switchable columns. |
Sql Help
Browse through the topics in MySQL's built in help system. |
Updatecheck
Keeps your HeidiSQL version up to date with the latest features and bugfixes. Can be invoked automatically by option. |