HeidiSQL

From TheAlmightyGuru
Jump to: navigation, search

HeidiSQL is a database explorer which supports querying and updating MariaDB, MySQL, PostgreSQL, SQL Server, and SQLite over a variety of communication protocols. The program was first released on April 2006 and is named after the book, Heidi.

Tricks

Importing null

Although the export feature supports a variety of options for how to export a null value, the only option the import feature supports is the value NULL without quotes.

Changing the background color

In the Advanced tab of the Session Manager, you can change the background color of a session. However, it doesn't include a custom color picker, so you're stuck with the unhelpful colors chosen by the programmers. You can change this to a custom color by doing the following:

  1. Open the Registry.
  2. Expand the tree view to HKEY_CURRENT_USER\SOFTWARE\HeidiSQL\Servers.
  3. Expand the connection you want.
  4. In the keys list, double-click TreeBackground.
  5. Colors are stored in a 4-byte hex value with the bytes (from left to right) signifying: Modifier, Blue, Green, Red.

If the Modifier is 00, the color will be interpreted as a custom BGR color. If it's FF, the last byte will be a Windows system color. The value "1FFFFFFF" is used for no custom color.

Links

Link-Wikipedia.png  Link-Official.png