MySQL Front 4 2 Build 2 7

MySQL-Front is a graphical GUI management tool for the MySQL database. Because it is a "real" application, it can offer a more refined user-interface than is possible with systems built on PHP and HTML. Defining and managing the database-structure, importing data, editing data is now simple with this full-featured program. For designers with only a basic grasp of databases, this program is the way to go to make you independent of SQL gurus. Response is immediate, as there is no delay of reloading HTML-pages. As a Windows MySQL GUI application, it has total control of the graphic display; information can be presented as clearly as possible. Your data is presented in a table with resizable column-widths and sorting capability.

If your provider allows it, MySQL-Front can make direct contact with the database. Otherwise, only one small script needs to be installed on the publishing website. Login information (and passwords if wanted) are stored on your hard disk, so you no longer have to log on to different web interfaces.MySQL-Front presents a uniform front-end for all of your current database projects. In practice, you can work with the database of your choice after only a few clicks.

MySQL-Front makes working with MySQL databases a snap without hiding the language from the user. The built-in SQL Editor provides syntax highlighting and context sensitive help, so even working with SQL commands and scripts will be a matter of convenience.

High-Degree of Compatibility:

* Supports MySQL databases starting with version 3.23
* Direct database access without using the MySQL DLL to reduce installing and connecting problems
* If desired, use of the MySQL DLL to access the database and thus compatible with future versions
* If the ISP prohibits external access to the database a HTTP tunnel can be used to have access the database nevertheless
* Full Drag&Drop and Copy&Paste support
* Intensive internal usage of the Windows API to make sure to be compatible with future Windows versions

Ease of Use:

* Windows-conformant use of all elements
* Clearly structured menu prompts
* Efficient use either via keyboard or with mouse only
* Data structure depiction same as in Windows Explorer
* Interactive dialogs to edit the entire data structures
* Data depiction within a customizable data grid
* Detailed manual
* Very fast because of efficient engineering and usage of the multi statement support

Individual Configuration:

* Language settings (more than 30 languages available, unicode supported)
* Design settings
* Various options to configure the database connection
* Numerous program use settings
* Syntax highlighting with individual colors

Standard Database Editing:

* Create, change and delete databases, tables, views, procedures, functions, events, triggers, indices, fields and foreign keys
* Create, change and delete data inclusive. Memo / BLOB using a HEX editor
* Display graphics in BLOB data (BMP, GIF, JPEG, PNG and RTF)
* Full Unicode support for data and identifiers
* Table partitioning support

Data / Data Structure Import:

* SQL File
* Text File (CSV format)
* MS Access File
* MS Excel File
* ODBC (Open Database Connector)

Data / Data Structure Export:

* SQL File
* Text File (CSV format)
* HTML File
* XML File
* MS Excel File

Enhanced Database Manipulations:

* Detailed Search inside whole table(s) / database(s) with regular expressions
* Fast Search&Replace inside whole table(s) / database(s)
* Whole database / table transfer between two different servers
* Easy Synchronisation between two databases / tables

Database Administration:

* Overview and ending of single processes and the entire server
* Detailed server status overview
* Configuration of server variables
* Highly individualized user rights administration
* Security settings on host level
* Table maintenance support (check, analyze, optimize, repair and "flush tables")
* Showing server error log

Rapid development:

* All database objects can be created, changed and removed without writing any SQL statement
* Database queries can be developed with a visual query builder by Drag&Drop very fast
* Context sensitive help of the SQL in the SQL Editor
* Executing partial selected SQL statements in the SQL Editor
* Editing values in the result set of an executed query in the SQL Editor and Query Builder
* Management of user-defined SQL scripts
* The source of Stored Procedures, Stored Functions, Triggers and Events can be edit like in a text in the notepad - MySQL-Front handle the updates with a single key pressing

Efficient Troubleshooting:

* Distinct filtering and data sorting functions
* Logging of SQL queries sent to the database
* Display of source code of databases, tables, views, routines, events, triggers, users, hosts and processes
* Stored Procedures, Stored Functions, Triggers and Events can be executed for debugging with a single mouse click. Test data can be set and the result will be shown right beside the source code editor
* Printout of data, data structure and source code syntax highlighting
* Management of user-defined SQL scripts