MySQL shell on Windows


The command line interface to MySQL works perfectly well in itself, but when using my local copy I'm forced to interact with it using the old-fashioned DOS windows. Is there some way I can redirect it through a better shell?


You should give a try to SQLyog. It has very powerfull query editor with features including Auto-complete, Auto-indentation, Customize foreground and background colours, Flexibiility to execute multiple MySQL queries in one go, and a long list to go... SQLyog Documentation for Query Tab

SQLyog's Query Tab Screenshot

Hope it helps...

By : Shubhansh

It sounds like a GUI is not really what you were after, but maybe HeidiSQL would be worth a look. It's a GUI frontend for MySQL which I wouldn't say I quite enjoyed using, but I've certainly come across worse ways to talk with a database.

Have you tried the MySQL Query Browser? Works cross platform and is much nicer than the plain shell.

By : Tom

This video can help you solving your question :)
By: admin