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,...
Platforms: *nix
License: Freeware | Size: 6.14 KB | Download (119): SQLizer Download |
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...
Platforms: *nix
License: Freeware | Size: 25.6 KB | Download (99): DBIx::XMLMessage Download |
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
License: Freeware | Size: 11.26 KB | Download (88): DBIx::HTML::ClientDB Download |
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
License: Freeware | Download (47): Query constructor Download |
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
License: Freeware | Download (50): PipisCrew.QueryAnalyzerPlus Download |
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
License: Freeware | Size: 3.74 MB | Download (46): Database Command Executor Download |
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
License: Freeware | Size: 10 KB | Download (42): MySQL DB Class and Data Manipulation Class Download |
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
License: Freeware | Size: 10 KB | Download (44): Search Query Generator for MySQL Database Download |
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
License: Freeware | Size: 10 KB | Download (48): My One Line SQL Download |
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
License: Freeware | Size: 20.48 KB | Download (36): Sheba Download |
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
License: Freeware | Size: 153.6 KB | Download (94): Tangram::Type::Extending Download |
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
License: Freeware | Download (93): SqliteQuery Download |
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
License: Freeware | Download (52): QueryAnalyzerPlus Download |
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
License: Freeware | Download (60): OracleEditor.php Download |
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
License: Freeware | Size: 10 KB | Download (43): Small MySQL Connection Download |
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
License: Freeware | Size: 10 KB | Download (43): OracleEditor.php for Scripts Download |
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
License: Freeware | Size: 10 KB | Download (40): DB Populator Download |
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
License: Freeware | Size: 10 KB | Download (42): MySQL DB Connector Download |
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
License: Freeware | Size: 51.2 KB | Download (42): Data to XML Download |
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
License: Freeware | Size: 215.04 KB | Download (38): Ujorm Download |