VBcoders Browse New Submit Contact Sign In

No account? Register free

Forgot password?

mySQL Query Analyzer

Jimmy C. Broadhead, Jr.  (1 Submission)   Databases/Data Access/DAO/ADO   VB Script   Advanced   Wed 3rd February 2021

myAnalyzer is a simple query analyzer that allows users to run SQL Statements to their mySQL database. This program does not use ADO but rather connects directly to mySQL through the DLL file included with mySQL (this through the help of some code borrowed from an individual mentioned inside the code). myAnalyzer also allows the user to save the sql query as well as print the query or it's results. The program has full search capabilities and can run multiple queries in one window or multiple queries through several databases in an MDI environment. I hope this benefits others out there as I wrote it to help me debug my SQL queries for my apps. You can connect to your mySQL server through a logon screen, or pass the information through to the exe from another application or command line.

Inputs
myAnalyzer.exe hostname, username, password

Assumes
You MUST have mySQL server installed and have the libmySQL.dll available for DLL calls.

API Declarations
See Code

Rate mySQL Query Analyzer (15(15 Vote))

Download mySQL Query Analyzer

mySQL Query Analyzer Comments

No comments yet — be the first to post one!

Post a Comment

0/1000 characters