Saturday, November 21, 2015

What is HeidiSQL?

It is a client tool used by web developers for working with MySQL Server, Microsoft SQL databases and PostgreSQL. It is free, Open Source since 9 years of active development and very useful.

What all HeidiSQL can do?

HeidiSQL which is a client application can carry out a lot of data related tasks:
•Connect to multiple servers in one window
•Connect to servers via command line
•Connect via SSH tunnel, or pass SSL settings
•Create and edit tables, views, stored routines, triggers and scheduled events.
•Generate nice SQL-exports, compress these afterwards, or put them on the clipboard.
•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

Where do you install HeidiSQL?

Download the HeidiSQL 9.3 Installer here. There are other options as well. Double clicking the executable begins the installation.
Here are some screen shots.

 Agree to license terms and click Next.

 Accept default folder.

Chose not to associate for now.

 Launches HeidiSQL Session if the checkbox is checked.

 Leaves a new app on All Apps in Windows 10

It also enters the Programs and Features list in Control Panel.

No comments: