Select Sql

TextSQL can parse some types of SQL queries and translate the queries into actions to store and retrieve data from text files.CREATE TABLE, INSERT and SELECT SQL queries are supported.

CuteSQL is a freeware utility for all database fans. It allows you to execute SQL commands and queries against any database. Available connections: Native, via ODBC or via ADO. Directly supported databases: Oracle, MS SQL, Interbase, DB2, MySQL and more...Key features: user-friendly interface;...

MySQL cache class can be used to cache MySQL query results in session variables. MySQL cache script used in PHP, it is a professional PHP cache script.It can perform a given SELECT SQL query and store the result in a session variable.Next time the same query is executed it can retrieve the...


Platforms: Matlab

migratedata project allows you to write a simple XML file to define how to copy data from one database to another, and perform very simple transformations on the way. Currently, it is immediately able to help you migrate a PostNuke web site to a WordPress one, but to perform any other...


Platforms: *nix

uni PHP DataGrid is a simple, innovative and powerful tool for generating data-bound grid control, specially designed for Web developers. It is useful for all PHP database- driven Web site and online-based data administration. It is also useful for dynamic content management and PHP-based...


Platforms: *nix

MyJSQLView provides an easy to use Java based GUI, graphical user interface, frontend for viewing, adding, editing, or deleting data in the MySQL, PostgreSQL, & HSQL databases.A query tool allows the building of complex SELECT SQL statements. The application allows easy sorting, searching, and...


Platforms: Java

igiOz Datagrid can be used to browse data from a given MySQL table to display it using HTML tables. It executes a SELECT SQL query to retrieve data from a given table.The data is retrieved into an array of a limited number of rows that corresponds to the current result page to display. The data...


Platforms: PHP

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


Platforms: *nix

SQL VB ASP Code Generator is a powerful multi-purpose tool that lets you effortlessly generate SQL, VB and ASP Code. You can even generate an entire VB application or ASP web application, all derived from the tables in your database with just one click. No more recreating the same old SELECT,...


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 Engine can execute SELECT, INSERT, UPDATE and DELETE queries. It takes care of emulating auto-increment fields if these are not supported, using sequences.SQL Engine can also create a new database table or alter its fields if the table already exists. A separate class can be used to log the...


Platforms: PHP

Apache SQL analyser can query Apache logfiles via SQL. asql is a simple console shell which allows you to run SQL queries against an Apache logfile, something that can be very useful - especially at getting information which is not easily available via static logfile analysers. An overview of...


Platforms: *nix

DBIx::SQL::Abstract is a Perl module that provides a convenient abstraction layer to a database. SYNOPSIS use DBIx::SQL::Abstract; my $dbh = DBIx::SQL::Abstract->new( %dbcfg ); Building SQL Abstractions. my($query, @bind) = $dbh->select($table, @fields, %where, @order); my($query,...


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

SQL::Preproc is a Perl module to embed SQL in your Perl (ala SQL preprocessors). SYNOPSIS use SQL::Preproc subclass => Chart, emit => 1, keepsql => 1, syntax => [ Teradata ], pponly => 1, relax => 1, alias => 1, debug => 1; use DBI; use DBI qw(:sql_types); use...


Platforms: *nix

SQL::Statement::Embed can embed a SQL engine in a DBD or module. SQL::Statement is designed to be easy to embed in other modules and to be especially easy to embed in DBI drivers. It provides a SQL Engine and the other module needs to then provide a data source and a storage mechanism. For...


Platforms: *nix

SQL::Amazon::Request::Help is an Interface to retrieve Help content. SYNOPSIS $dbh = DBI->connect(dbi:Amazon:, $amznid, undef, { amzn_mode => books, amzn_locale => us, amzn_max_pages => 3 }) or die "Cannot connect: " . $DBI::errstr; # # search for some Perl DBI books # $sth =...


Platforms: *nix

SQL::Amazon::UserGuide is a Perl module with user Guide for DBD/SQL::Amazon. SYNOPSIS # # create the parser, passing in the current Amazon metadata # my $parser = SQL::Amazon::Parser->new(%attrs); # # parse a SQL statement, returning a SQL::Amazon::Statement # my $stmt =...


Platforms: *nix

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


Platforms: *nix

EMS SQL Query for SQL Server is an easy to use software that enables you to quickly build SQL queries to Microsoft SQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and...


Platforms: Windows