Download HeidiSQL 5.1 stable

Previous releases can be downloaded at Google Code.

HeidiSQL runs fine on Windows (2000, XP, Vista, 7) and on any Linux with Wine.

Nightly Builds of heidisql.exe RSS Feed

Latest automatically compiled main executable for HeidiSQL. Just download and overwrite your existing C:\Program Files\HeidiSQL\heidisql.exe (or whatever).

Be aware that these builds are not official releases and therefore probably have more bugs, possibly serious ones!

Link to latest build

Revision Compiled .EXE Notes
3465 heidisql.r3465.exe 4737K

Committed: Mon, 26 Jul 10 21:16, Compiled: Mon, 26 Jul 10 21:17

Store last session name at disconnect time instead when when connecting. Fixes issue #2102.

Build log
3464 heidisql.r3464.exe 4737K

Committed: Sat, 24 Jul 10 15:32, Compiled: Sat, 24 Jul 10 15:32

If a session is configured to prompt for username + password, only prompt on the initial connect, not on each reconnection, which is annoying and superfluous.

Build log
3463 heidisql.r3463.exe 4737K

Committed: Sat, 24 Jul 10 15:23, Compiled: Sat, 24 Jul 10 15:23

Add button right besides recent filter pulldown menu, for clearing data grid related stuff for selected table, session or all sessions. Fixes issue #2096.

Build log
3462 heidisql.r3462.exe 4735K

Committed: Tue, 20 Jul 10 09:55, Compiled: Tue, 20 Jul 10 09:55

Minor code cosmetic

Build log
3461 heidisql.r3461.exe 4735K

Committed: Tue, 20 Jul 10 09:53, Compiled: Tue, 20 Jul 10 09:54

Apply more unique icon to SQL export action, so it has a different one than the grid export action.

Build log
3460 heidisql.r3460.exe 4735K

Committed: Tue, 20 Jul 10 09:42, Compiled: Tue, 20 Jul 10 09:43

Table editor fails to detect the default collation on some tables. Fetch it from SHOW TABLE STATUS instead as fallback. See http://www.heidisql.com/forum.php?t=6202

Build log
3459 heidisql.r3459.exe 4735K

Committed: Tue, 20 Jul 10 08:29, Compiled: Tue, 20 Jul 10 08:29

Fix date time grid editor for YEAR data type. Fixes issue #2078.

Build log
3458 heidisql.r3458.exe 4735K

Committed: Mon, 19 Jul 10 22:06, Compiled: Mon, 19 Jul 10 22:06

Session manager: Add checkbox option for users who want to be prompted for username + password rather than saving that to registry. Prompt window itself is called from within TMySQLConnection.SetActive.

Build log
3457 heidisql.r3457.exe 4731K

Committed: Sat, 17 Jul 10 17:10, Compiled: Sat, 17 Jul 10 17:10

Add context popup menu on column list which allows hiding/displaying single columns. Also fixes hidden collation column after having introduced the new zerofill column in r3441.

Build log
3456 heidisql.r3456.exe 4731K

Committed: Fri, 16 Jul 10 19:44, Compiled: Fri, 16 Jul 10 19:45

Immediately call popup text editor for cells which either contain line breaks or huge text over 100k. Fixes issue #1651.

Build log
3455 heidisql.r3455.exe 4731K

Committed: Fri, 16 Jul 10 19:17, Compiled: Fri, 16 Jul 10 19:22

Fix query splitter: "DELIMITER xyz" must be followed by some space char, this is not optionally. Broken in r3432. Fixes issue #2092.

Build log
3454 heidisql.r3454.exe 4731K

Committed: Thu, 15 Jul 10 00:36, Compiled: Thu, 15 Jul 10 00:36

FocusedColumn may also be "InvalidColumn" (-2) when the relevant grid column is hidden. Fixes issue #2088.

Build log
3453 heidisql.r3453.exe 4731K

Committed: Wed, 14 Jul 10 12:58, Compiled: Wed, 14 Jul 10 12:59

Triggers need to be exported after tables, just like views. Fixes issue #2077.

Build log
3452 heidisql.r3452.exe 4731K

Committed: Wed, 14 Jul 10 12:52, Compiled: Wed, 14 Jul 10 12:52

Table editor: Apply default length/set for new columns as long as user didn't touch it. Fixes issue #2084.

Build log
3451 heidisql.r3451.exe 4731K

Committed: Tue, 13 Jul 10 21:24, Compiled: Tue, 13 Jul 10 21:25

Remove code which is never executed - BLOB preview is done internally, not via temporary file.

Build log
3450 heidisql.r3450.exe 4732K

Committed: Tue, 13 Jul 10 21:22, Compiled: Tue, 13 Jul 10 21:22

Fix exceptions triggered when some grid cell editors are destroyed, e.g. by accessing the registry too late. Hopefully fixes issue #2046.

Build log
3449 heidisql.r3449.exe 4731K

Committed: Tue, 13 Jul 10 19:59, Compiled: Tue, 13 Jul 10 19:59

Attempt to fix some memory leaks in TMySQLQuery, when it gets destroyed. Should already be done by the compiler but who knows, probably this fixes issue #2063.

Build log
3448 heidisql.r3448.exe 4731K

Committed: Tue, 13 Jul 10 18:55, Compiled: Tue, 13 Jul 10 18:55

Remove dead code

Build log
3447 heidisql.r3447.exe 4731K

Committed: Tue, 13 Jul 10 16:54, Compiled: Tue, 13 Jul 10 16:55

Add "Clear file list" to query load menu. Fixes issue #2082.

Build log
3446 heidisql.r3446.exe 4731K

Committed: Sun, 11 Jul 10 22:13, Compiled: Sun, 11 Jul 10 22:14

Remove 3 dead constants

Build log
3445 heidisql.r3445.exe 4731K

Committed: Sun, 11 Jul 10 20:56, Compiled: Sun, 11 Jul 10 20:56

Add LIMIT 1 clause to grid UPDATE queries, to make these safer on tables without sufficient unique key. Fixes issue #2079.

Build log
3444 heidisql.r3444.exe 4731K

Committed: Wed, 07 Jul 10 19:07, Compiled: Wed, 07 Jul 10 19:07

Add fallback when trying to detect length of column. Fixes an AV in rare special cases.

Build log
3443 heidisql.r3443.exe 4731K

Committed: Mon, 05 Jul 10 20:31, Compiled: Mon, 05 Jul 10 20:32

Do not trigger completion proposal in query editors when cursor is inside a comment. Fixes issue #2070.

Build log
3442 heidisql.r3442.exe 4731K

Committed: Mon, 05 Jul 10 19:30, Compiled: Mon, 05 Jul 10 19:30

Force reinitializing nodes in ListDatabases when connecting. Fixes issue #1491, the hot tracking AV.

Build log
3441 heidisql.r3441.exe 4731K

Committed: Sun, 04 Jul 10 15:35, Compiled: Sun, 04 Jul 10 15:36

Add support for ZEROFILL flag in table editor. Introduces a new checkbox column in the columns list. Fixes issue #570.

Build log
3440 heidisql.r3440.exe 4731K

Committed: Sun, 04 Jul 10 12:59, Compiled: Sun, 04 Jul 10 13:00

Bring back database filter pulldown, for users who dislike to create one session per filter. Fixes issue #2054.

Build log
3439 heidisql.r3439.exe 4727K

Committed: Sat, 03 Jul 10 01:26, Compiled: Sat, 03 Jul 10 01:27

Remove Mince() function to shorten a file path - setting a label's EllipsisPosition to epPathEllipsis does the same.

Build log
3438 heidisql.r3438.exe 4728K

Committed: Sat, 03 Jul 10 01:08, Compiled: Sat, 03 Jul 10 01:08

Remember state of WordWrap button on text and hex editor. Fixes issue #2055.

Build log
3437 heidisql.r3437.exe 4728K

Committed: Sat, 03 Jul 10 00:58, Compiled: Sat, 03 Jul 10 00:58

Add menu item for inserting UNIX timestamp into grid cells. Fixes issue #2060.

Build log
3436 heidisql.r3436.exe 4727K

Committed: Sat, 03 Jul 10 00:43, Compiled: Sat, 03 Jul 10 00:43

Text and hex editor forms have "toolwin" style, which prevents the app from appearing when pressing Alt+Tab. Additionally, Alt+Tab leaves the app in foreground when such a window had focus. This is a Windows issue, as one can read here: http://edn.embarcadero.com/article/26050 . Set both forms back to bsSizable, fixes issue #2061.

Build log
3435 heidisql.r3435.exe 4727K

Committed: Fri, 02 Jul 10 18:48, Compiled: Fri, 02 Jul 10 18:48

Minor: Enhance wording on grid export caption. No need to mention all 6 different export formats in one short caption.

Build log
3434 heidisql.r3434.exe 4727K

Committed: Fri, 02 Jul 10 00:44, Compiled: Fri, 02 Jul 10 00:44

After disconnecting, accessing an old TMySQLQuery's connection can result in unhandled exceptions. Catch all of them in TMainForm.tabsetQueryGetImageIndex, not just those of which we're aware of. Fixes issue #2048.

Build log
3433 heidisql.r3433.exe 4728K

Committed: Fri, 02 Jul 10 00:03, Compiled: Fri, 02 Jul 10 00:03

Do not raise, just put a log info when previously focused db or table is gone after refreshing. This is a normal case when db or table was deleted from outside or via query. Fixes issue #2059.

Build log
3432 heidisql.r3432.exe 4728K

Committed: Thu, 01 Jul 10 21:45, Compiled: Thu, 01 Jul 10 21:45

Adjust offset stuff in SQL splitter routine, DELIMITER department. Fixes issue #2053.

Build log
3431 heidisql.r3431.exe 4728K

Committed: Thu, 01 Jul 10 20:58, Compiled: Thu, 01 Jul 10 20:58

When copying HTML from grid rows, StreamToClipboard needs its 3rd parameter set to true to create the required clipboard header for rich text editors. Also, calculate values for StartHTML and EndHTML - seems required by Mozilla based applications like Thunderbird. Fixes unformatted HTML pasted into rich text editors.

Build log
3430 heidisql.r3430.exe 4728K

Committed: Thu, 01 Jul 10 01:37, Compiled: Thu, 01 Jul 10 01:37

Foreign key constraint symbol names must be unique in a database. To avoid violation errors the "Copy table" dialog should just leave the CONSTRAINT clause out from the CREATE TABLE code. In that case MySQL auto creates a valid name on demand. See http://www.heidisql.com/forum.php?t=6086

Build log
3429 heidisql.r3429.exe 4727K

Committed: Thu, 01 Jul 10 01:21, Compiled: Thu, 01 Jul 10 01:21

Add support for exporting grids as Wiki table markup

Build log
3428 heidisql.r3428.exe 4726K

Committed: Thu, 01 Jul 10 00:34, Compiled: Thu, 01 Jul 10 00:35

Merge 5 GridToXYZ export routines into one, so there is less code to maintain and to make it easier to add further export formats.

Build log
3427 heidisql.r3427.exe 4732K

Committed: Wed, 30 Jun 10 20:31, Compiled: Wed, 30 Jun 10 20:31

Create query tab array early enough so we don't access them before by actDataPreviewExecute(). Fixes an AV on startup when preview panel was active.

Build log
3426 heidisql.r3426.exe 4732K

Committed: Mon, 28 Jun 10 23:57, Compiled: Mon, 28 Jun 10 23:57

Assign hotkeys to controls on search and replace dialog. See http://www.heidisql.com/forum.php?t=5801

Build log
3425 heidisql.r3425.exe 4732K

Committed: Mon, 28 Jun 10 21:49, Compiled: Mon, 28 Jun 10 21:50

Increase auto calculated column width slightly, so the flashing "..." button has room when editing cells, without cutting text. Fixes issue #2051.

Build log
3424 heidisql.r3424.exe 4732K

Committed: Fri, 25 Jun 10 08:36, Compiled: Fri, 25 Jun 10 08:36

Remove superfluous uses unit.

Build log
3423 heidisql.r3423.exe 4732K

Committed: Fri, 25 Jun 10 08:35, Compiled: Fri, 25 Jun 10 08:35

Use the right expression group when detecting "AT" date. Fixes issue #2041.

Build log
3422 heidisql.r3422.exe 4732K

Committed: Tue, 22 Jun 10 07:39, Compiled: Tue, 22 Jun 10 07:40

Be sure later calls to SetRecNo are executed after discarding a new grid row. Fixes issue #2031.

Build log
3421 heidisql.r3421.exe 4732K

Committed: Mon, 21 Jun 10 20:30, Compiled: Mon, 21 Jun 10 20:30

If a file does not contain a BOM, do not advance the stream position for later readers. Fixes issue #2035.

Build log
3420 heidisql.r3420.exe 4731K

Committed: Mon, 21 Jun 10 12:00, Compiled: Mon, 21 Jun 10 12:00

Trim db names to ignore such minor typos. Fixes issue #2036.

Build log
3419 heidisql.r3419.exe 4731K

Committed: Mon, 21 Jun 10 08:03, Compiled: Mon, 21 Jun 10 08:03

Do not overtake empty strings in semicolon separated list of databases. Fixes issue #2032.

Build log
3418 heidisql.r3418.exe 4731K

Committed: Sun, 20 Jun 10 18:59, Compiled: Sun, 20 Jun 10 18:59

Do not annoy user with error popup when accessing table data in information_schema.

Build log
3417 heidisql.r3417.exe 4731K

Committed: Sun, 20 Jun 10 18:45, Compiled: Sun, 20 Jun 10 18:45

Make data in VIEWs editable again by fetching table name and column names in a slightly different way. Fixes issue #1999.

Build log
3416 heidisql.r3416.exe 4731K

Committed: Sun, 20 Jun 10 14:32, Compiled: Sun, 20 Jun 10 14:32

Restrict "Select all" action to Ctrl+A, do not trigger it on Ctrl+Alt+A or AltGr+A. Fixes issue #2027.

Build log
3415 heidisql.r3415.exe 4730K

Committed: Sun, 20 Jun 10 12:05, Compiled: Sun, 20 Jun 10 12:06

Use TOpenTextFileDialog instead of TOpenDialog for two places where we load SQL and text cell contents. That dialog has an additional "Encoding" dropdown, where the user can select the file's encoding, which can be required if the auto detection did not succeed. Fixes issue #2025.

Build log
3414 heidisql.r3414.exe 4727K

Committed: Fri, 18 Jun 10 20:17, Compiled: Fri, 18 Jun 10 20:17

Remove remaining wrong \r\n text from LaTeX output.

Build log
3413 heidisql.r3413.exe 4727K

Committed: Fri, 18 Jun 10 19:00, Compiled: Fri, 18 Jun 10 19:00

Tweak LaTeX export: Fix case in all occurrences of "LaTex" - must be "LaTeX" and remove trailing "\r\n" in output.

Build log
3412 heidisql.r3412.exe 4727K

Committed: Fri, 18 Jun 10 18:52, Compiled: Fri, 18 Jun 10 18:52

Split identifiers with dot only in explicit cases, so column names containing a dot can be loaded and created. Fixes issue #2026.

Build log
3411 heidisql.r3411.exe 4726K

Committed: Fri, 18 Jun 10 18:32, Compiled: Fri, 18 Jun 10 18:32

Implement LaTeX output for "Copy as" actions. Code parts from brampton. Fixes issue #2020.

Build log
3410 heidisql.r3410.exe 4725K

Committed: Thu, 17 Jun 10 00:58, Compiled: Thu, 17 Jun 10 00:59

Apply non-redundant shortcut Ctrl+Shift+F to "Filter panel", instead of Ctrl+F which is used for "Find text" in query editors. Fixes issue #1907.

Build log
3409 heidisql.r3409.exe 4725K

Committed: Thu, 17 Jun 10 00:52, Compiled: Thu, 17 Jun 10 00:52

Load all rows in data grid when pressing Ctrl+End. Fixes issue #1949.

Build log
3408 heidisql.r3408.exe 4725K

Committed: Thu, 17 Jun 10 00:30, Compiled: Thu, 17 Jun 10 00:30

Fix recently broken support for views in "Copy table" dialog.

Build log
3407 heidisql.r3407.exe 4724K

Committed: Wed, 16 Jun 10 21:12, Compiled: Wed, 16 Jun 10 21:13

When total command count is very low, percentage values in command stats tab were miscalculated. Fixes issue #2015.

Build log
3406 heidisql.r3406.exe 4724K

Committed: Wed, 16 Jun 10 20:55, Compiled: Wed, 16 Jun 10 20:55

Fix wrong "DROP [index name]" clause when turning a normal key into a primary key. Fixes issue #2011.

Build log
3405 heidisql.r3405.exe 4724K

Committed: Wed, 16 Jun 10 20:19, Compiled: Wed, 16 Jun 10 20:19

Enhance wrapped text in result tab hint text. See issue #2014.

Build log
3404 heidisql.r3404.exe 4724K

Committed: Tue, 15 Jun 10 20:36, Compiled: Tue, 15 Jun 10 20:37

Implement recent filters in "Copy table" dialog, selectable via button + dropdown menu.

Build log
3403 heidisql.r3403.exe 4723K

Committed: Tue, 15 Jun 10 19:13, Compiled: Tue, 15 Jun 10 19:13

Wrap hint text at 100 chars. Fixes issue #2014.

Build log
3402 heidisql.r3402.exe 4722K

Committed: Tue, 15 Jun 10 00:52, Compiled: Tue, 15 Jun 10 00:52

Tweak copy table dialog:
- display number of checked/total child nodes per option node
- display row count on "Data" option
- remove plus button from disabled option nodes, and do not check them
- code cosmetic

Build log
3401 heidisql.r3401.exe 4721K

Committed: Mon, 14 Jun 10 23:50, Compiled: Mon, 14 Jun 10 23:50

Reset FRecNo after executing a new query, otherwise SetRecNo does nothing if FRecNo was already 0. Fixes issue #2009.

Build log
3400 heidisql.r3400.exe 4721K

Committed: Mon, 14 Jun 10 19:28, Compiled: Mon, 14 Jun 10 19:29

Enhancement: Prompt if target table exists, ask if it shall be dropped before creating the new table copy.

Build log
3399 heidisql.r3399.exe 4720K

Committed: Mon, 14 Jun 10 19:19, Compiled: Mon, 14 Jun 10 19:19

Bugfix: Only disable WHERE memo on first level "Data" node, not on second level nodes.

Build log
3398 heidisql.r3398.exe 4720K

Committed: Mon, 14 Jun 10 08:04, Compiled: Mon, 14 Jun 10 08:04

Enhancement: Disable "Indexes" and "Foreign keys" node to indicate they have 0 child nodes

Build log
3397 heidisql.r3397.exe 4720K

Committed: Mon, 14 Jun 10 08:03, Compiled: Mon, 14 Jun 10 08:03

Bugfix: Mixed check state also means that this node was checked

Build log
3396 heidisql.r3396.exe 4720K

Committed: Mon, 14 Jun 10 02:21, Compiled: Mon, 14 Jun 10 02:21

Refactor "Copy table" dialog:
* Replace checkboxes, radio buttons and checklistbox by a VirtualTree using checkbox support
* Support selecting/deselecting single indexes
* Support foreign keys
* Place a SynMemo at the bottom in which the user can type an optional WHERE clause to filter incoming data. Fixes issue #2000.
* Move code for SQL generation into TTableColumn etc.

Build log
3395 heidisql.r3395.exe 4694K

Committed: Sun, 13 Jun 10 16:39, Compiled: Sun, 13 Jun 10 16:40

Focus previous privilege tree node after deletion. Fixes issue #853.

Build log
3394 heidisql.r3394.exe 4694K

Committed: Sun, 13 Jun 10 12:21, Compiled: Sun, 13 Jun 10 12:21

Tweak auto setting column widths in datagrid: do not recalculate them on "Quick filter" clicks. Fixes issue #2005.

Build log
3393 heidisql.r3393.exe 4694K

Committed: Sat, 12 Jun 10 02:38, Compiled: Sat, 12 Jun 10 02:39

Find a way to fix issue #1970 again, this time without breaking remembered data grid node/col as in r3385. Fixes issue #2007.

Build log
3392 heidisql.r3392.exe 4694K

Committed: Fri, 11 Jun 10 23:04, Compiled: Fri, 11 Jun 10 23:05

Make grid scrolling incredibly much faster, by exiting early in SetRecNo if current row is already the right one. See http://www.heidisql.com/forum.php?t=5890

Build log
3391 heidisql.r3391.exe 4694K

Committed: Fri, 11 Jun 10 21:52, Compiled: Fri, 11 Jun 10 21:53

Immediately prepare editing when data grid fetches rows, as that implicitly fixes BLOBs detection and enables "Image preview" action. Fixes issue #1948.

Build log
3390 heidisql.r3390.exe 4694K

Committed: Fri, 11 Jun 10 21:39, Compiled: Fri, 11 Jun 10 21:39

Build log
3389 heidisql.r3389.exe 4693K

Committed: Fri, 11 Jun 10 18:56, Compiled: Fri, 11 Jun 10 18:56

Set and fetch default height of PageControl via constant rather than from the control itself, as that may not be created that early. A minimal chance that this fixes issue #1995.

Build log
3388 heidisql.r3388.exe 4694K

Committed: Fri, 11 Jun 10 00:19, Compiled: Fri, 11 Jun 10 00:19

Avoid endless loop in SQL help topics tree on broken help tables, by displaying a category node as topic item if has the same name as its parent category. Fixes issue #1988.

Build log
3387 heidisql.r3387.exe 4694K

Committed: Thu, 10 Jun 10 21:05, Compiled: Thu, 10 Jun 10 21:05

Repeat automatic calculating optimal column widths in data grid on refresh, as long as user did not resize some column. Fixes issue #2005.

Build log
3386 heidisql.r3386.exe 4693K

Committed: Thu, 10 Jun 10 20:48, Compiled: Thu, 10 Jun 10 20:48

Keep scroll offset when refreshing data grid. Fixes issue #2003.

Build log
3385 heidisql.r3385.exe 4693K

Committed: Thu, 10 Jun 10 19:40, Compiled: Thu, 10 Jun 10 19:40

Reset stored db and table names when dbtree focus changed, so the grid also refreshes when you add or remove column(s) in the table editor, switch to another table and then back. Fixes issue #1970.

Build log
3384 heidisql.r3384.exe 4693K

Committed: Thu, 10 Jun 10 10:37, Compiled: Thu, 10 Jun 10 10:38

Fix sporadic AV reported in forum: http://www.heidisql.com/forum.php?t=5911#p5925

Build log
3383 heidisql.r3383.exe 4693K

Committed: Thu, 10 Jun 10 00:48, Compiled: Thu, 10 Jun 10 00:48

Fix detected end offset of DELIMITER query.

Build log
3382 heidisql.r3382.exe 4693K

Committed: Thu, 10 Jun 10 00:42, Compiled: Thu, 10 Jun 10 00:43

Don't know what I meant to fix by this split-and-combine-again code, as it only has the effect that lines get trimmed. Remove that code. Fixes issue #2002.

Build log
3381 heidisql.r3381.exe 4693K

Committed: Thu, 10 Jun 10 00:24, Compiled: Thu, 10 Jun 10 00:24

Avoid an AV in cases when main tab is "Data" on startup.

Build log