Writing Sql Queries
SQL Handling Functions is a MySQL database access wrapper that can execute common SQL queries.Functions of SQL Handling Functions:- Establish connections to a MySQL host and access a given database- Execute INSERT or UPDATE SQL queries to a given table and a list of fields- Get the last inserted...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (41): SQL Handling Functions Download |
Caches the results of SQL queries transparently. FYI, this isn't complete yet, there's probably still a lot of bugs. Also, this whole project might just be a bad idea since it caches everything. I'll probably add options for excluding tables and limiting the size of queries that can be cached....
Platforms: *nix
License: Freeware | Size: 10.24 KB | Download (42): django-query-caching Download |
Active Query builder is a component suite for Borland Delphi and C++ Builder which gives your end-users the ability to create SQL queries containing unions and sub-queries via an intuitive visual interface. Free Edition supports only the ANSI dialect
Platforms: Windows
License: Freeware | Size: 2.68 MB | Download (269): Active Query Builder Free Edition Download |
PhpBuns generates SQL queries and web pages written in PHP. It makes it possible to, among other things, generate the queries and the pages for adding, editing, deleting, listing or retreiving data from an SQL database. It uses AdoDB (http://php.weblogs.com/ADODB) as an abstraction layer for...
Platforms: *nix
License: Freeware | Size: 2.5 MB | Download (95): phpBuns Download |
ODBCbadger is an advanced application that allows you to easily manage and store the ODBC connections and manage SQL queries.
Main features:
-You can store your SQL commands in a treeview in the form of easily manageable nodes.
-Inside the sql command you can use variables such as &NAME...
Platforms: Windows
License: Freeware | Size: 459 KB | Download (113): ODBCbadger Download |
SOCI is a database access library for C++ that makes the illusion of embedding SQL queries in the regular C++ code, staying entirely within the Standard C++.
The idea behind SOCI is to offer C++ programmers a way to access SQL databases in the most natural way.
If you find existing libraries...
Platforms: Windows
License: Freeware | Download (45): SOCI Download |
Active Query Builder VCL Edition is a visual query builder component suite for Borland Delphi and C++ Builder that allows your end-users to build SQL queries with unions and subqueries via an intuitive visual interface.
Active Query Builder VCL Edition is a useful utility that allows you to...
Platforms: Windows
License: Freeware | Download (54): Active Query Builder VCL Free Edition Download |
MuSQL is designed to simultaneously execute your SQL queries, DML statements, PL/SQL blocks, and entire SQL*Plus scripts in multiple Oracle databases quickly and effortlessly.
Take MuSQL for a test drive to see what it's really capable of!
Platforms: Windows, XP, 2003, Windows Vista
License: Freeware | Download (44): MuSQL Download |
AnalogX SQLCMD is a simple way to run SQL queries from a batch file, or have a command line based SQL query tool. It allows you to specify a database, username and password (if necessary), and a SQL query you wish to perform. The results are either output to the screen, or alternatively output...
Platforms: Windows
License: Freeware | Size: 56 KB | Download (432): AnalogX SQLCMD Download |
About iSQL-Viewer
- Scripting support using JPython and the IBM BSF framework
- A guided query builder for creating simple and complex SQL queries
- Enhanced object viewing for images, HTML, and other binary format files
- A friendly SQL console for executing SQL statements
- Batch processing...
Platforms: Mac
License: Freeware | Size: 3.4 MB | Download (49): iSQL-Viewer 2.1.8 Download |
JustQueryIt is a php class that grows up adodb and let you able to separate sql queries and php code.It can also execute parametric queries in a really simple way.Now you can include in the simplest way you can imagine your data into your html pages.
Platforms: PHP
License: Freeware | Size: 245.76 KB | Download (49): JustQueryIt Download |
With this software you can make simple SQL queries to a MySQL database without knowing too much SQL.This software uses Perl/Tk for the graphical interface.Usage- Install the included DBD-mysql-3.0008.tar.gz and Tk-804.027.tar.gz Perl modules if you don't already have them or updated versions of...
Platforms: CGI and Perl
License: Freeware | Size: 5.87 MB | Download (49): Simple Database Script Download |
EasySQL classes provides the same interface to compose and execute SQL queries to access several types of SQL databases: MySQL, PostgreSQL and SQLite.The script provides simple methods that will help to compose and execute SQL queries of the types: SELECT, INSERT, UPDATE, DELETE and...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (41): EasySQL classes Download |
JustQueryIt is a php class that grows up adodb and let you able to separate sql queries and php code.It can also execute parametric queries in a really simple way.Now you can include in the simplest way you can imagine your data into your html pages.
Platforms: PHP
License: Freeware | Size: 204.8 KB | Download (42): JustQueryIt for Scripts Download |
Several functions, that can be used to compose and execute common SQL queries by passing a list of parameters defining tables, fields and conditions, are added to the ezSQL class with CRUDitdoTes.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (41): CRUDitdoTes Download |
PHP MySQL Database Class can establish connections to a MySQL server and execute arbitrary SQL queries.Key Features of PHP MySQL Database Class:- Fetch query results into an array- Execute SELECT, INSERT, UPDATE and DELETE queries from parameters that define tables, fields, field values and...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (39): PHP MySQL Database Class Download |
True MySQL class can connect to a specified MySQL host, execute SQL queries and retrieve the results into arrays or objects.Key Features of True MySQL class:- Seek SQL query result sets- Get the number of affected rows and the identifier of the last record inserted by a query- Retrieve the names...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (40): True MySQL class Download |
A connection to a MySQL database is opened and several types of SQL queries are built and executed.Key Features of MYDB Class:- SELECT queries given the table, list of fields and an optional condition clause- INSERT or UPDATE queries given the table, list of fields and values and an optional...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (40): MYDB Class Download |
Simple and Speed MySQL Layer establishes a connection to a MySQL host, executes SQL queries and retrieves results as objects or in an array.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (40): Simple and Speed MySQL Layer Download |
A connection to a specified MySQL server is established and SQL queries are executed.Key Features of WG DB Class:- Retrieve query results into arrays- Retrieve the result set number of rows, last inserted identifier or the number of affected rows- Check if a database table record exists matching...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (43): WG DB Class Download |