Nested Sql Select Statements

logindpostgres is a script that reads SQL select statements from PostgreSQL logs and generates all the indices to optimize the database for each request. logindpostgres has been tested on 1.2 GB of logs.. Get Postgres 8.1 Intelligent Index generator at SourceForge.net. Fast, secure and free...

SQL::Interpolate is a Perl module to interpolate Perl variables into SQL statements. SYNOPSIS use SQL::Interpolate qw(:all); # Some sample data to interpolate: my $s = blue; my @v = (5, 6); # Variable references are transformed into bind parameters. # The most basic usage involves...

Find Foreign Keys. Effortless Data Models. SQL Made Simple. Attention Developers, Crystal Report Professionals and Data Analysts: The mystery hiding inside your database has just been solved. idxScout investigates keys, indexes and design problems with automatic data modeling. Point it to...


Platforms: Windows

SQL SELECT, INSERT, UPDATE and DELETE queries can be generated with the specified table name, arrays of fields and corresponding values and the additional clauses.


Platforms: PHP

SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. You can choose to create an individual .sql file for each...


Platforms: Windows

LiveDataScript is a handy utility for Microsoft SQL Server 2005 and 2008 that allows you to script data from a database into SQL insert statements. The application features and easy to use interface, that will make your work even easier. for WindowsXP, Vista, 7


Platforms: Windows, Windows Vista, 7

SQL SELECT queries can be executed and the fields of each result set row can be retrieved into class variables.Object based MySQL can also insert or update records of a table getting the values from class variables with the same name as the fields.


Platforms: PHP

Oh!DB Table Data Gateway can perform the following operations:- Execute SQL SELECT queries from list of fields of a table- Retrieve the highest or the lowest value from an integer primary key table field- Get or delete one record of a table with a given primary key value- Delete all records of a...


Platforms: PHP

sql4array can execute SQL SELECT queries on bi-dimensional array, for which the first dimension is the row number and the second dimension the field names.The WHERE clause can be used to specify conditions with operators such as =, >,The results are returned as arrays and can be sorted with the...


Platforms: PHP

SQL SELECT queries can be executed to retrieve values of individual rows with a specified primary key value into an array.DELETE queries can be executed to remove rows with a given primary key value.


Platforms: PHP

Easy Connect to MySQL is a very simple class that can be used to connect to a MySQL database and execute a SQL SELECT query.It consists of a single function that does everything at once: connects to a given MySQL database, executes a given SELECT query and returns the query results in a...


Platforms: PHP

sql_query_generator will generate a large range of SQL SELECT queries from a submitted form.It provides facilites for simple queries on one field on a table, joins, selection of fields to be returned, aliasing of fields (eg. SUM(Price) AS Total), ORDER BY, even multiple queries from one...


Platforms: PHP

View Access,Foxpro,dBase,Excel.Oracle and any ODBC enable Database on UIQ mobile phone like Sony Ericsson P800 or P900.View database tables: all at a time or record at a time.Apply SQL Select queries on database to purify records by adding filter. View database tables: all at a time or record at...


Platforms: Symbian

The DataKiosk project is a JuK-like database interface tool for generic SQL databases. What does that mean? Essentially, DataKiosk provides a series of wizards (anyone familiar with Qt Designer's database wizards will find them familiar) that allow you to build a custom Juk-like interface for any...


Platforms: *nix

MDB Viewer Plus is a freeware viewer plus editor for Microsoft Access MDB and Accdb database files. It does not require an install to run provided that Microsoft Data Access Components (MDAC) is installed on your PC (In most versions of Windows this is the case). MDB Viewer Plus has been...


Platforms: Windows

SQL::Schema is a Perl module to convert a data dictionary into SQL statements. SYNOPSIS use DBI; my $dbh = DBI->connect(...); use SQL::Schema; my $schema = SQL::Schema->new($dbh); my $sql = $schema->string; print $sql; print "$schema"; WARNING This is alpha software. It...


Platforms: *nix

Advanced SQL To XML Query is a relational database client utility that allows execution of SQL (Structured Query Language) statements on Microsoft SQL Server databases. Resultsets returned by select statements are automatically converted to XML files and persisted to a directory of your choice....


Platforms: All

Due to the complexity of the SQL grammar, many people have attempted but failed to generate a successful parser. Here, at Gudu Software, we have developed a parser that can successfully reduce the difficulties associated with decoding SQL grammar. Vendors are constantly releasing new versions of...


Platforms: Windows

This is a plugin that transform Kate into a simple, light, versatile and useful SQL client. It take the advantages of the Qt Sql module to allow you to open connections with all supported SQL drivers (MySQL, PostgreSQL, SQLite, ODBC, etc...) and easily launch queries on database. Some of the main...


Platforms: *nix

SQL::Abstract::Limit is a portable LIMIT emulation. SYNOPSIS use SQL::Abstract::Limit; my $sql = SQL::Abstract::Limit->new( limit_dialect => LimitOffset );; # or autodetect from a DBI $dbh: my $sql = SQL::Abstract::Limit->new( limit_dialect => $dbh ); # or from a Class::DBI class: my...


Platforms: *nix