Nested Sql Select Statements

SQLizer is a Java utility library intended for generating sql from the search input. Synopsis: import stanford.netdb.utils.*; String sql_1 = Feild2SQL.parseField(type,table, column, input_str, field_display_name, post_filter); String sql_2 = Feild2SQL.parseStringField(table, column,...

DBIx::XMLMessage is a Perl module for XML Message exchange between DBI data sources. The package maintains simple XML templates that describe object structure. The package is capable of generating SQL statements based on these templates and executing them against DBI data sources. After...

DBIx::HTML::ClientDB is a Perl module to convert sql into a client-side db with keyed access. Synopsis use DBIx::HTML::ClientDB; my($object) = DBIx::HTML::ClientDB -> new ( dbh => $dbh, row_headings => Unit code,Unit code,Campus name,Unit name, sql => select unit_code, unit_code,...


Platforms: *nix

Query constructor is a handy, simple, easy to use application specially designed to offer you a structured visual SQL text constructor. Help manage and edit text in standard SQL (SELECT queries only). for WindowsAll


Platforms: Windows

PipisCrew.QueryAnalyzerPlus is an easy-to-use application designed to help you manipulate dbase servers. You can connect to Access mdb files / SQL Server / SQLCe sdf files / SQLite db files. Once connected your can type and run SQL statements, when tables loaded into treeview there are various...


Platforms: Windows, XP, 2003, Windows Vista, XPX64, 2008, 7, 7x64, 2008x64, 2008R2, 832-bit, 864-bit

This is a simple utility that can perform a sql commands on a database. You can execute an insert, update or delete commands as well as select statements. Utility returns the number of processed records as its ExitCode and you can also save the results (selected records or the processed records...


Platforms: Windows

The base calls establishes MySQL database connections, sanitizes values used in SQL queries, executes SQL queries, retrieves SELECT query results into arrays and retrieves the last inserted identifier.There is also a sub-class that can retrieve the list of fields of a table, compose and execute...


Platforms: PHP

Search Query Generator for MySQL Database is a very simple class that can be used to build a SQL WHERE clause for performing a query that search for given field values.Search Query Generator for MySQL Database takes as parameter an associative array with the field names as indexes and the field...


Platforms: PHP

Several types of common queries can be run with a single call by using eventual parameters to define queries that take variable values.Key Features of My One Line SQL:- SELECT what FROM tablename- SELECT what FROM tablename WHERE where_expression- SELECT what FROM tablename ORDER BY...


Platforms: PHP

Sheba offers SQL management for people that don't mind SQL. Motivation I can write SQL faster than I can figure out the various library and ORM abstraction layers. Writing SQL directly in code is pretty disgusting. So I stole an idea from the Axamol SQL Library and along with a couple updates...


Platforms: *nix

Tangram::Type::Extending is a Perl module for teaching Tangram about new types. Tangram::Type is the root of a hierarchy of classes that are responsible mapping individual field to SQL entities (columns in the simplest cases). There is one Type object per persistent field. Adding support for...


Platforms: *nix

SqliteQuery is a utility for executing SQL statements on SQLite databases. You can edit and maintain existing databases or create new ones through the user-interface. SqliteQuery comes with the compiled SQLite database library built-in.The main purpose of SqliteQuery is to execute SQL statements...


Platforms: Mac

QueryAnalyzerPlus is an easy-to-use application designed to help you manipulate dbase servers. You can connect to Access mdb files / SQL Server / SQLCe sdf files / SQLite db files. Once connected your can type and run SQL statements, when tables loaded into treeview there are various procedures...


Platforms: Windows, XP, 2003, Windows Vista, XPX64, 2008, 7, 7x64, 2008x64, 2008R2, 832-bit

OracleEditor.php is a standalone PHP script which allows you to browse your Oracle database tables and insert, update, and delete rows in any table. It requires no installation and no configuration. Features: - Connects to any Oracle database (local databases, aliases from tnsnames.ora, or...


Platforms: Windows, Mac, *nix, PHP, BSD Solaris

This class Small MySQL Connection is a very simple wrapper to access a MySQL database.Functions of Small MySQL Connection:- Establish database connections- Execute manipulation queries and return the number of affected table rows- Execute an SQL SELECT queries and return the result set data in a...


Platforms: PHP

OracleEditor.php is a standalone PHP script which allows you to browse your Oracle database tables and insert, update, and delete rows in any table. It requires no installation and no configuration.Features:- Connects to any Oracle database (local databases, aliases from tnsnames.ora, or complete...


Platforms: PHP

This class can be used to populate a MySQL database with random data. It can scan the list of tables and fields of a MySQL database and generate SQL INSERT statements that will fill the tables with records with random data.The class tries to populate each record field with values that seem...


Platforms: PHP

MySQL DB Connector connections to a MySQL database server can be established using the MySQLi extension.The script can compose and execute SQL SELECT, INSERT, UPDATE and DELETE queries from lists of parameters that define tables, fields, field values and condition clauses.


Platforms: PHP

Data to XML can be used to generate XML documents from data stored in a MySQL database. It can execute a given SQL SELECT query and generate a XML document with query result data.


Platforms: PHP

Ujorm is an quick and easy-to-use ORM solution for Java with a small footprint. Some of its features are type safe parameters in queries, a memory overloading protection cache and relation mapping by Java code rather through proxy objects or entity states. Why a new ORM mapping? * framework has...


Platforms: *nix