mySQL Tools

Forum for any discussion not Dawn of Light related

Moderator: Support Team

mySQL Tools

Postby Ukobat » Thu Sep 08, 2011 10:08 pm

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
Ukobat
DOL Apprentice
 
Posts: 35
Joined: Thu Sep 08, 2011 6:43 am

Re: mySQL Tools

Postby Argo » Thu Sep 08, 2011 11:10 pm

well and when you screw around with daoc... HeidiSql too, happy screwing :mrgreen:
Möge Gott sein zwischen Dir und dem Leid, an allen dunklen und verlassenen Orten, die Du erreichen wirst.
Argo
Server Team
 
Posts: 1760
Joined: Thu Sep 18, 2008 6:21 pm
Location: Berlin, Germany

Re: mySQL Tools

Postby Dunnerholl » Fri Sep 09, 2011 6:50 am

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.
Dunnerholl
Developer
 
Posts: 1229
Joined: Mon Sep 08, 2008 8:39 pm

Re: mySQL Tools

Postby Tolakram » Fri Sep 09, 2011 8:41 am

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

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

I think both have SQL syntax highlighting.
- Mark
User avatar
Tolakram
Storm / Storm-D2 Admin
 
Posts: 9189
Joined: Tue Jun 13, 2006 1:49 am
Location: Kentucky, USA

Re: mySQL Tools

Postby Ukobat » Fri Sep 09, 2011 10:36 am

ty Tola this will work
Ukobat
DOL Apprentice
 
Posts: 35
Joined: Thu Sep 08, 2011 6:43 am

Re: mySQL Tools

Postby Graveen » Fri Sep 09, 2011 12:16 pm

HeidiSQL have syntax highlightning - in the query tab.
Notepad++ also.
Image
* pm me to contribute in Dawn of Light: code, database *
User avatar
Graveen
Project Leader
 
Posts: 12661
Joined: Fri Oct 19, 2007 9:22 pm
Location: France

Re: mySQL Tools

Postby THE_Wolfman » Tue Sep 27, 2011 6:56 am

Grab Programmer’s Notepad 8)

It's free, comes in installer, multilanguage installer, and portable flavors.
THE Wolfman
former DOL Developer
User avatar
THE_Wolfman
Inactive Staff Member
 
Posts: 135
Joined: Sat Jun 21, 2003 4:17 am

Re: mySQL Tools

Postby Argo » Tue Sep 27, 2011 7:16 am

nice one Wolfman, just downloaded and tried it. nifty little editor :)
Möge Gott sein zwischen Dir und dem Leid, an allen dunklen und verlassenen Orten, die Du erreichen wirst.
Argo
Server Team
 
Posts: 1760
Joined: Thu Sep 18, 2008 6:21 pm
Location: Berlin, Germany

Re: mySQL Tools

Postby Dinberg » Thu Sep 29, 2011 10:48 am

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 :P
The Marvelous Contraption begins to stir...
User avatar
Dinberg
Inactive Staff Member
 
Posts: 4695
Joined: Sat Mar 10, 2007 9:47 am
Yahoo Messenger: dinberg_darktouch
Location: Jordheim

Re: mySQL Tools

Postby Argo » Thu Sep 29, 2011 2:35 pm

got that notepad++ too and as you said, it is always one of the first things i install on any pc :D
Möge Gott sein zwischen Dir und dem Leid, an allen dunklen und verlassenen Orten, die Du erreichen wirst.
Argo
Server Team
 
Posts: 1760
Joined: Thu Sep 18, 2008 6:21 pm
Location: Berlin, Germany

Re: mySQL Tools

Postby Graveen » Fri Sep 30, 2011 12:56 am

idem. I regret replacing notepad with notepad++ is so (relatively) difficult.
Image
* pm me to contribute in Dawn of Light: code, database *
User avatar
Graveen
Project Leader
 
Posts: 12661
Joined: Fri Oct 19, 2007 9:22 pm
Location: France

Re: mySQL Tools

Postby Argo » Fri Sep 30, 2011 9:19 am

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.
Möge Gott sein zwischen Dir und dem Leid, an allen dunklen und verlassenen Orten, die Du erreichen wirst.
Argo
Server Team
 
Posts: 1760
Joined: Thu Sep 18, 2008 6:21 pm
Location: Berlin, Germany

Re: mySQL Tools

Postby Graveen » Fri Sep 30, 2011 2:28 pm

yes, i use it for years, and i make it replacing notepad, but as notepad is a system file, it can scare newcomers :D
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 ! :)
Image
* pm me to contribute in Dawn of Light: code, database *
User avatar
Graveen
Project Leader
 
Posts: 12661
Joined: Fri Oct 19, 2007 9:22 pm
Location: France

Re: mySQL Tools

Postby Argo » Fri Sep 30, 2011 8:53 pm

not to forget the replacing possibilities through macro automating :D my favourit for working on mysql files
Möge Gott sein zwischen Dir und dem Leid, an allen dunklen und verlassenen Orten, die Du erreichen wirst.
Argo
Server Team
 
Posts: 1760
Joined: Thu Sep 18, 2008 6:21 pm
Location: Berlin, Germany

Re: mySQL Tools

Postby Dinberg » Sat Oct 01, 2011 7:14 pm

and iirc you can specify what regex flavor you want to use!
The Marvelous Contraption begins to stir...
User avatar
Dinberg
Inactive Staff Member
 
Posts: 4695
Joined: Sat Mar 10, 2007 9:47 am
Yahoo Messenger: dinberg_darktouch
Location: Jordheim


Return to “%s” Other Discussion

Who is online

Users browsing this forum: No registered users and 0 guests