Free resultset software for windows

SQLyog 8.14 is well-known as a simple yet effective tool that is designed to enable you to import data from ODBC datasource, synchronize your database.

Execute queries for updation of result. Copy databases between hosts. Generate Schema for your database. Manage Foreign Relationships and all options fully InnoDB compliant. Reorder columns.

SQLyog is an easy to use, compact and very fast graphical tool to manage your MySQL database anywhere in the world. SQLyog is a tool that allows you manage MySQL database.

Major Features:

1. Query Profiling Tools
   • Query Profiler
     
2. Visual Tools
   • SQL Formatter
3. Visual Query Builder
   • Visual Schema Designer
4. Migration Tools
   • Wizard Driven Migration Toolkit
   • Import tasks can be scheduled
5. Synchronization Tools
   • Schema Synchronization
   • Data Synchronization
   • Data Synchronization can be scheduled
6. Other Power Tools
   • Scheduled Backups
   • Notification Services
   • Job Manager
7. Internationalization
   • Complete Unicode/UTF8 Support
8. DBA Productivity
   • Restoring/Importing large SQL dumps
   • MySQL 5.x objects support
   • User Management
   • Managing hosted MySQL
   • Connection Manager
   • Index Management
   • Relationship/Foreign Key Manager
   • Reorder Columns
   • Copy objects to another Host with single click
   • Table diagnostics
   • Flush Tools
   • Object Browser
   • Creating/dropping database
   • Optimized for managing Hosted MySQL
   • Multiple database connections
   • Table duplication with two clicks
9. Licensing
   • Perpetual Licensing
   • Company wide Unlimited licensing at very attractive prices
10. Enhanced Productivity
    • Smart Autocomplete
    • Intelligent Code Completion
11. Advanced Connectivity Options
    • HTTP Tunneling
    • HTTPs Tunneling
    • SSH Tunneling
    • SSL Connections
12. Developer / User Productivity
    • Favorites Manager
    • HTML Schema Documentation
    • Shortcuts to generate SQL DML statements from schema definition
    • Creating/Dropping/Altering tables
    • Multi-tab Query Editor and Result-set Editor
    • Multiple Query Execution
    • Multi-threaded Query execution - Ability to stop long running queries
    • SQL Templates
    • Excel-style grid interface to view/update resultsets
    • Multi-format Blob editor
    • View data in Grid/Text Mode
    • ResultSet/Data Export to CSV/XML/HTML/Excel
    • Full Support from 3.23.38 to the latest 5.x
    • Support for all MySQL table handlers
    • Excel friendly resultsets/table-data export to clipboard/file
    • Dialog-less table and resultset editor
13. Technology
    • Turbo Speed MySQL Management. Uses native MySQL C API - the fastest way
    • to communicate with MySQL server
    • 100% keyboard friendly
    • Small compact binary
    • Minimal use of Registry
    • Easy migration of User Preferences by dragging and dropping config files.
    • Non-cluttered look and feel, ability to show/hide panes

H2 is an SQL database engine written in Java (but also available as a native binary). JDBC and ODBC APIs are supported. Embedded and server modes are available. A Web console application is included. Clustering is supported.H2 Database Engine is a web based java database engine.
Main features:
- Fast database engine
- Free, source code is included
- Supports standard SQL
- Written in Java
- Disk based or in-memory databases
- Browser base Console application
- JDBC API
- Limited ODBC support
- Embedded and client/server (network) mode
- High availablility support (clustering / failover)
- Wide range of data types including large objects (BLOB/CLOB)
- Strong security features (SSL, users, roles, encrypted files)
- Multiple connections, table level locking
- Cost based optimizer, using a genetic algorithm for complex queries
- Transaction support (serializable transaction isolation)
- Zero-administration, automatic recovery
- Large resultset, external sorting
- Scrollable and updatable resultset support
- Read only views and inline views
- Inner and outer joins, subqueries
- Many functions already built-in
- Triggers and Java functions / stored procedures
- Referential integrity / foreign key constraints with cascade, check constraints
- Multiple schema support
- Compatibility modes for HSQLDB, MySQL and PostgreSQL
- Sequence and autoincrement columns
- Well tested (high code coverage, randomized stress tests)
- Small footprint (smaller than 1 MB)
- Uses a small number of database files
- Can be compiled to native code using GCJ
- Primary keys, multiple index types (b-tree, linear hash, tree, hash)
- ORDER BY, GROUP BY, HAVING, UNION, LIMIT
- Information Schema
- Multiple connections
- Collation support
- EXPLAIN PLAN support
- The database can generate SQL script files
- Support for linked tables, and a built-in virtual range table
- Automatic re-compilation of prepared statements
- Sophisticated trace options
- Low memory requirements
- Easy to understand exception messages
- Standard handling of NULL values
- Multilanguage console application (at this time, English and German)

SQLyog is a compact Win32 Front End for the MySQL database server. The program is aimed at users that are familiar with SQL statements and need an easy to use, no fuss, graphical interface to execute SQL queries.
SQLyog MySQL GUI is a software that allows you to execute queries.
The program supports execution of multiple queries and selected (highlighted) or single queries and offers a template explorer to quickly insert commonly used queries, such as create table, insert, drop table, rollback and others.
In addition, you can export data in CSV, HTML & XML format and Import from a text file. Export data and schema itself, flush hosts/logs and more. In addition, SQLyog allows you to diagnose and optimize your databases, save your favorite SQL scripts in favorite folders and more.
Main features:
- Favorites Manager
- HTML Schema Documentation
- Shortcuts to quickly generate SQL statements and paste object names
- Learn MySQL by looking at the SQL generated by SQLyog
- Multi-tab Query Editor and Result-set Editor
- Multiple Query Execution
- Multi-threaded Query execution with option to stop long running queries
- SQL Templates
- Excel-style grid interface to view/update resultsets
- Multi-format Blob editor
- View data in Grid/Text Mode
- ResultSet/Data Export to CSV/XML/HTML
- Full Support from 3.23.38 to the latest 5.x
- Support for all MySQL table handlers
- Excel friendly resultsets/table-data export to clipboard/file
- Dialogless table and resultset editor
- Restoring / Importing large SQL dumps
- MySQL 5.x objects support
- User Management
- Managing hosted MySQL
- Connection Manager
- Index Management
- Relationship/Foreign Key Manager
- Reorder Columns
- Copy objects to another Host with single click
- Table diagnostics
- Flush Tools
- Object Browser
- Creating/dropping database
- Optimized for managing Hosted MySQL
- Profiling
- Multiple database connections

QuickTable can be created in just 4 simple java statements! No complex API.
DBTable dBTable1 = new DBTable();
dBTable1.connectDatabase(
"oracle.jdbc.driver.OracleDriver",
"jdbc:oracle:thin:@myServer:1526:myInstance",
"username" ,
"password");
dBTable1.setSelectSql("select * from employee");
dBTable1.refresh();
It is even made more simple, if you have a jdbc resultset. With one statement, you can load the resultset into quicktable.
dBTable1.refresh(yourResultSet);