Creating Queries Mysql Workbench
SELECT, INSERT, UPDATE and DELETE queries can be executed from lists of parameters defining tables, fields, field values and condition clauses with MySQL Database Layer With Dynamic SQL Generators.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (42): MySQL Database Layer With Dynamic SQL Generators Download |
The query results can be retrieved into arrays with MySQL access class.Key Features of MySQL access class:- Connect to a given MySQL database server host- Execute SQL queries- Execute queries that return the number of rows that a given SQL query would return- List the database tables
Platforms: PHP
License: Freeware | Size: 10 KB | Download (44): MySQL access class Download |
This script can execute MySQl queries build from parameters. It can establish connections to MySQL database servers using configuration loaded using a separate auxiliary script.The MySQL script can execute INSERT, UPDATE, DELETE, SELECT queries and stored procedure calls from parameters that...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (40): Secured mySQL Layer Download |
SDB simple MySQL script implements a wrapper to access MySQL databases. This script allows easy data control from PHP to MySQL.Here are some key features of "SDB simple MySQL class":- Create tables- Lock tables- Optimize all database tables- Truncate tables- Establish database connections-...
Platforms: PHP
License: Freeware | Size: 20.48 KB | Download (43): SDB simple MySQL class Download |
Use this script Simple to Use PHP MySQL Class that I've been using for years in my projects. It's a really easy-to-use PHP class file for connecting to, running queries on and retrieving data from MySQL databases.Just include the file, and set four parameters and you're all hooked up ready to go!
Platforms: PHP
License: Freeware | Size: 10 KB | Download (44): Simple to Use PHP MySQL Class Download |
MySQL DB Management Class can access a MySQL database and execute SQL queries retrieving the results into arrays in a single call.MySQL DB Management Class can also show links to browse the query results split among multiple pages.INSERT and UPDATE can be executed from lists of parameters.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (46): MySQL DB Management Class Download |
There are two classes that provide the same functionality to access MySQL databases. The second class provides static functions and creating class objects is not necessary to call it.When used together with and error handler class/function that also logs stacktrace (like my ErrorManager class)...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (40): Ultimate MySQL wrapper Download |
DigiOz MySQL Database Class is a simple MySQL database access wrapper class.DigiOz MySQL Database Class can establish MySQL database connections, execute SQL queries and return the results as single row arrays, as a multiple row bidimensional array, or the number of rows in the result set, and...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (45): DigiOz MySQL Database Class Download |
MySQL Restore can be used to execute batches of MySQL database queries read from files or text strings. It can be useful to restore backups of MySQL database that generate SQL query lists meant for that purpose.The SQL data can be compressed with gzip algorithm. MySQL Restore can also build an...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (44): MySQL Restore Download |
DBI MySQL is MySQL database access wrapper.It can establish database connections, execute SQL queries, retrieve the query result set data, present SELECT query information details like the time it took to execute and the returned result rows.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (45): DBI MySQL Download |
MySQL Paginator can be used execute MySQL database SQL queries and display the results split in multiple HTML pages. It can connect to a given MySQL database and execute an SQL table.Then MySQL Paginator can display a limited number of results in an HTML table with links to navigate between the...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (44): MySQL Paginator Download |
Touzas MySQL is a simple MySQL database access wrapper class for executing common SQL queries.Touzas MySQL provides functions for establishing database connections and executing SELECT, INSERT, UPDATE and DELETE SQL statements.Limitations:The code and the comments are in Spanish.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (45): Touzas MySQL Download |
This is tool to run by orders and decrees databases and tables MySQL.
Using it you can easy create/drop base or table, edit data in table, create SQL queries...
You can use database server by network.
Platforms: Windows
License: Freeware | Size: 529 KB | Download (331): Simple MySQL Manager Download |
SQLyog is a compact Win32 Front End for the MySQL database server. The program is aimed at users that are familiar with SQL statements and need an easy to use, no fuss, graphical interface to execute SQL queries. The program supports execution of multiple queries and selected (highlighted) or...
Platforms: Windows
License: Freeware | Size: 34 MB | Download (614): SQLyog MySQL GUI Download |
DreamCoder for MySQL Free Edition is a free graphical tool for database development and administration.
DreamCoder for MySQL Free Edition enhances productivity and simplifies your database development and administration process with a functionality and friendly GUI.
DreamCoder for...
Platforms: Windows
License: Freeware | Size: 10.34 MB | Download (1030): DreamCoder for MySQL Free Edition Download |
PHP Generator for MySQL is a freeware but powerful MySQL GUI frontend that allows you to generate high-quality MySQL PHP scripts for the selected tables, views and queries for the further working with these objects through the web. Key features include: data management abilities (adding, editing...
Platforms: Windows
License: Freeware | Size: 5.29 KB | Download (263): PHP Generator for MySQL Download |
Easy and quick database administration, natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. Main features: Creating and restoring backups. Transfer data between databases, tables and data files (supported formats are XML, CSV, HTML, Excel). Edit database schema, tables, views, view,...
Platforms: Windows, *nix
License: Freeware | Size: 3.81 MB | Download (259): DatAdmin Personal Download |
MyProfi project is a command line tool that parses mysql query log and outputs statistics of most frequently used queries, sorting them by number of times they appear in a log file. The similar queries are groupped together. Thus, select id from user where login="admin" and select id from user...
Platforms: *nix
License: Freeware | Size: 6.14 KB | Download (97): MyProfi 0.161 Download |
MySQA program is a useful program to analyze log files created by MySQL slow queries or queries that dont use indexes. About MySQL: MySQL is a multithreaded, multi-user, SQL (Structured Query Language) Database Management System (DBMS) with an estimated six million installations. MySQL AB...
Platforms: *nix
License: Freeware | Size: 133.12 KB | Download (92): MySQA Download |
mtop (MySQL top) monitors a MySQL database showing the queries which are taking the most amount of time to complete. Installation: To install mtop, run the following: perl Makefile.PL make make install Run: perl Makefile.PL --prefix={install_prefix} or change the PREFIX line in...
Platforms: *nix
License: Freeware | Size: 49.15 KB | Download (90): mtop Download |