myDBView - The ultimate MySQL data viewer and admin tool

myDBView provides user accounts and privileges management, visual table designer and report builder.

Here are some key features of "myDBView":

· Simple and clean tree-view oriented visual application interface. All objects within server are hierarhicaly organized starting with the server through the databases an finnishing with the table and SQL objects
· Viewing and managing data from the different servers and databases at the same time.
· Simple user acount and privileges management. Create new users on the server, edit the user privileges, remove users from the server.
· Easilly create and delete databases on the server. Create, delete and rename tables in the database.
· All commands are available through popup menues by right-clicking on the objects in tree-view or on the data shown in the grid.
· Simple table structure overview with all the fields, keys, null values and default values. Easy and simple way to add, remove and edit fields, set and remove primary key, set and remove keys, complex keys and unique keys. Set and remove default values for the field values!
· Simple and powerfull reporting tool! Report builder powered by FastReport3. Create the best reports with built-in tool. And don't forget, it's free!
· Easilly comparation of the structures of the tables. It is posible to compare all the tables in database at once!
· Extracting table structures from single table or from all tables in the database is two clicks away!
· Easy overview of the server status and variables, flushing server privileges and hosts and managing processes on the server.
· Checking tables on the server has never been so easy! It is posible to check a single table, all the tables in the database or ALL the tables on server with just two clicks!
· After checking the tables, it is posible to repair the broken tables by multiple selection of the tables and starting repairing process.
· Writing multiple SQL statements in one SQL object and executing all of them at once. In example, it is possible to drop table, create new table, insert some data in new table and then selecting the data from that table in one SQL file.
· SQL statements execution history. On the right side of the main window is the place where all executed SQL statements are recorded alltogether with the commands, results and error messages.
· Simple and efficient management of the SQL objects with the possibility to set different folders for saving them. That provides the possibility to form several sets of SQL objects and switching between them.
· A tools for quoting/unquoting of SQL statements in SQL objects. That enables easy copy/paste operations into any other development environment.
· Exporting data into MS Excel, HTML, XML and Text format. It is possible to export data from tables and from results of the SQL queries.
· Automatic hiding of the tables and SQL objects that have been inactive for some period of time. In the options, it is possible to set that period. That greatly increases simplicity of the tree-view.
· Powerfull QuantumExpress grid provides simple manipulation with the shown data, grouping, filtering, calculating field summaries and many more!
· It is possible to save the layout of the application. This means that you may save the positions and filters of the all opened tables and SQL objects and load them any time later!
· Supports "Copy/Paste" and "Copy/Paste structure" operations on the tables. This means that copying and moving the tables or only table structures from one database to another is very, very easy!
· Supports breakpoints for efficient debugging of SQL objects.
· Supports editing of the BLOB fields