• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

sql debugger

 
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
is there such thing as sql debugger? for viewing the return result?

(I'm using mysql) thanks
 
Ranch Hand
Posts: 214
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
sure, I'll take a look at that. thanks for your reply
 
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic