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...

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

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

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

This tool converts SQL table or query results (multiple resultset) to MS Excel file (.xls file). With the help of Convert SQL to Excel you'll be able to easily turn SQL queries as well as tables into XLS files. This tool also allows you to convert/export multiple tables (multiple query results)...


Platforms: Windows, Windows Vista, 7, 7x64

Simple MySQL dump can be used to dump a MySQL database as a list of SQL statements. It can retrieve the database tables metadata and execute and SQL SELECT query to retrieve all the data of the tables to be dumped.Simple MySQL dump returns a string with the table creation and record insertion...


Platforms: PHP

EMS SQL Manager for Oracle is a high performance tool for Oracle Database Server administration and development. SQL Manager for Oracle works with any Oracle versions from 8.1.7 to 10g and supports all Oracle objects and all Oracle data types including the new BINARY_FLOAT and BINARY_DOUBLE...


Platforms: Windows

Entity Developer is a free powerful modeling and code generation tool for ADO.NET Entity Framework, NHibernate, and LINQ to SQL. You can use Model-First and Database-First approaches to design your model and generate C# or Visual Basic .NET code for it. It introduces new approaches for designing...


Platforms: Windows