This is done easily create a connection with the parameters "jdbc:mysql://localhost/testsquirrel" on the test database that I have created. Multiple sessions on different databases can be opened at the same time which allows to compare data or pass SQL statements between databases, something that could be for instance useful when you have a migration effort.The alias creation window allow you to "test" your parameters to make sure that they are right. Database structure editing After login, you can display a drop-down list of objects in your database in the "OBJECT" tab.SQuirre L's functionality can be extended through the use of plugins.Web Site: and Version Tested: SQuirre L SQL Client Snapshot-20090912_2118 to 20091128144, tested on Windows XP with My SQL 5.0.27, period from September to December 2009 License & Pricing: Open Source Support: User mailing list Installation The SQuirre L SQL Client is installed with the Iz Pack Java installer.
The SQL tab offer a syntax sensitive editor with a lot of associated tools, like an autocompletion tool that could be called by pressing ctrl space.You can also parameterize your SQL code, entering the value of a variable during execution of the script. Besides the predefined bookmarks already existing in the software, the user can add its own templates.All SQL statements are kept in history and could be recalled. An interesting Graph plugin allows creating charts of tables and foreign-key relationships., gather information from the form element to determine how to manage the submit process.
Both of these methods support numerous options which allows you to have full control over how the data is submitted.
SQuirre L SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, The minimum version of Java supported is 1.6.x as of SQuirre L version 3.0.