• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql debugger

 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
is there such thing as sql debugger? for viewing the return result?

(I'm using mysql) thanks
 
Edwin Keeton
Ranch Hand
Posts: 214
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do you just want to see query results? MySql has an administration tool that allows you to issue queries and see the results. There's also a command-line interface.

If you're looking to step through statements, I'm not aware of a specific tool that allows you to do this with mySql, although such tools do exist for other RDBMS and it would certainly be possible to develop one for MySql as well. I just don't know of one offhand. You can always use select statements to examine intermediate results.

By the way, I just recently heard that Quest has released TOAD for MySql. Don't know anything about it yet, but it might be worth taking a look at.
 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sure, I'll take a look at that. thanks for your reply
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Peter Primrose:
is there such thing as sql debugger? for viewing the return result?


I wouldn't really call them debuggers, but there are quite a number of general purpose SQL client applications that allow you to send an arbitrary SQL statement and view the result, as well as explore a database. Many of them are free and open source.

A partial list is here, it includes all the ones my coworkers favor:
http://java-source.net/open-source/sql-clients

There are also some commercial ones.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic