Hi everybody,
The new Version (1.18beta) of MySQL-Front is available: Download at
http://www.anse.de/mysqlfront/download.php
Again, this version comes with many bugfixes, enhancements and some new
features, which were requested by some users.
Changes to the last version:
- Removed access-violations on renaming and deleting tables
- Slightly reorganized main-menu-commands ("Extra" is now "Tools")
- Removed parse-error after SHOW PROCESSLIST
- New: Import databases through ODBC or directly read from MS-Access-Files
now! (beta-stadium)
- New: Table-Diagnostics - optimize, check, repair and analyze tables
through the menu-command "Tools"->"Table-Diagnostics" or directly through
the context-menu of one table
- New: Index-Editor - manage (concatenated) keys in the
field-editor-window
- Import Textfile: move columns up and down to customize your CSV-Data
- "Export tables" - 2 New ouput-options:
- Another Database on the same host
- A database on another host, which is connected by MySQL-Front. This
allows a direct replication between two MySQL-hosts(!)
- Database-Tree: if a database is selected, rightclick gives you a "Drop
Database"-command, if a table is selected, it shows a "Drop Table"-command
and the DB-command is disabled. In addition, I removed the shortcut "del",
because some users wrote me, that this can result in accidently removing a
database.
- Database-Tree: Refreshing the database-tree doesn't set the first entry
as selected item, but remembers the last selected table or database
- Database-Tab: If host-version >= 3.23.00, MySQL-Front uses SHOW TABLE
STATUS instead of SELECT COUNT(*) for each table. If version >= 3.23.00
Type, Creation-Time and Comment are additionally shown
- Database-Tab: Select more than one table at once now => Drop or Empty
multiple tables
- Data-Tab: Click on column-headers now for ordering records
- Data-Tab: updates and deletes within the data-tab without having a primary
key in a table are done with the pseudo-clause where Column1='foo' and
Column2='bar'... => therefore the message "No primary key is defined..."
was removed.
- Data-Tab: Fixed bug at deleting and updating records with multiple primary
keys, which had not the same sequence-order as the fields
- Data-Tab: On updates only changed fields are included in where-clause
- Data-Tab / Query-Tab: "Copy contents as HTML-Table" - makes a formatted
HTML-Table out of all rows and copies it to Clipboard
- Field-Editor now allows adding new fields between existing fields
- Preferences: Log last n lines in the SQL-history - this is especially
usefull, if you're executing very large SQL-Scripts, which were logged
after executing and wasting an enourmous amount of RAM
- Preferences: Configure your favorite color-coding scheme in
"Tools"->"Preferences"
- Query-Tab: Now click on the dropdown-menu-command "Selection", if you want
only a range of the sql-script to be executed.
- Query-Tab: When executing one or more queries, Errors are collected at
first and shown at the end of the script-execution. They don't stop the
whole SQL-script now.
---------------------------------------------------------------------
Thanks for your interest!
Greetings,
Ansgar Becker (Anse)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
