You are here: Home / Software Development / DBMS / HeidiSQL: Another Free MySQL Client Tools

HeidiSQL: Another Free MySQL Client Tools

Monday June 6, 2011 by  

I bet many of you know what is MySQL and probably use it a lot. One of the best MySQL client tools is MySQL Workbench as it have all fancy features. But it is too heavy to use. So instead of design the database structure, i’m using HeidiSQL to administrate my MySQL server. I found it extremely light and easy to use.

HeidiSQL is a lightweight, Windows based interface for MySQL databases. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers. (Source From HeidiSQL Official)

Why HeidiSQL? Well i use it often because it is light and fast. I like MySQL Workbench but it is not simple to use. I’m using HeidiSQL mostly to administrate my MySQL databases like clone, create and optimizing queries. And since HeidiSQL have good syntax highlighter and auto completion, it make more fun in building complex queries.

HeidiSQL Features

  • Connect to multiple servers in one window
  • Connect to servers via commandline
  • 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 and Wiki Markup
  • 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

Download HeidiSQL

Download HeidiSQL for Free

What people search:

Other Interesting Articles:

  1. [HowTo] Extract Database Information From Information_schema Table in Mysql [HowTo] Extract Database Information From Information_schema Table in Mysql
  2. Copy MySQL Data Across The Server Copy MySQL Data Across The Server
  3. [HowTo] Check And Repair MySQL Database [HowTo] Check And Repair MySQL Database
  4. Free Database Designer For MySQL With MySQL Workbench Free Database Designer For MySQL With MySQL Workbench

Article by

Ivan Kristianto is a profesional web developer and blogger. Very interest with free and open source software. Follow my Twitter: @ivankrisdotcom or Facebook profile IvanKristiantoBlog or Email me at ivan@ivankristianto.com

Category: DBMS
Tags: , , , ,

Post comment as
twitter logo facebook logo
Sort: Newest | Oldest