Dawn of Light

looking for a tool to read/edit mySQL's without having a server running
usually use HeidiSQL but that was when i was screwing around with WoW

anything > the view in notepad would be great

well and when you screw around with daoc... HeidiSql too, happy screwing

i think you will not get more than syntax highlighting and syntax checking from an offline tool. unfortunately i dont know any such tool for mysql.

notepad2 http://www.flos-freeware.ch/notepad2.html

notepad++ http://notepad-plus-plus.org/

I think both have SQL syntax highlighting.

ty Tola this will work

HeidiSQL have syntax highlightning - in the query tab.
Notepad++ also.

Grab Programmer’s Notepad

It's free, comes in installer, multilanguage installer, and portable flavors.

nice one Wolfman, just downloaded and tried it. nifty little editor

I give my shout out to Notepad++ (should be the first thing you install on ANY pc, maybe even before the OS!) and HeidiSQL. Hardcore users may of course use the command line tools

got that notepad++ too and as you said, it is always one of the first things i install on any pc

idem. I regret replacing notepad with notepad++ is so (relatively) difficult.

idem. I regret replacing notepad with notepad++ is so (relatively) difficult.

the possibilities look overwhelming at first sight but if you give it a try it is an awesome tool.

yes, i use it for years, and i make it replacing notepad, but as notepad is a system file, it can scare newcomers
For me, Notepad++ gives:
- syntaxic coloration to many files (quick changes to .cs, .php, .sql, .aut, .html are my main concerns)
- quick directory search
- regex search
- quick file compare
- quick text file conversion (line end linux/windows, ansi/utf8 conversion etc...)

Yay !

not to forget the replacing possibilities through macro automating my favourit for working on mysql files

and iirc you can specify what regex flavor you want to use!