by Jimmy C. Broadhead, Jr. (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: VB Script
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: 
(15 Votes)
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 DeclarationsSee Code
Download mySQL Query Analyzer (145 KB)
VBcoders