mikeSQL 5 Junior Poster

I just feel like posting this today because I had several people asking me on how to use this Desktop Applicaiton called MySQL Maestro.

Below is a self tip to help get you started and squared away for the most part. The rest once you get into it, youll pretty much make out to the areas and what-not:

To start working with a database in MySQL Maestro you should create a profile for that database through the Database | Create Database Profiles menu item, or by pressing Shift+Ctrl+P.
To close the current child window without exiting MySQL Maestro press Ctrl+W.
You can use F2 to rename a table in the explorer tree.
To sort database profiles alphabetically in the explorer tree select the Sort by Aliases option in the View | Explorer Options menu.
To be able to use query parameters in the SQL Editor or Query Builder check the 'Allow using parameters in query text' option on the Environment Options | Tools page.
You can export data from tables or queries to most popular formats, such as MS Excel, MS Access, MS Word, HTML, PDF, and other by clicking the Export Data item on the navigation bar of the table/query data tab.
You can import data to tables from MS Excel, MS Access, XML, and other formats by clicking the Import Data item on the navigation bar of the table data tab.
To bring the child window to its initial placement press Ctrl+P.
To enable multi-selection in the data grid use the appropriate option at the Environment Options | Data Grid page.
To continue executing SQL script even after error set the 'Abort script execution on error' option off at the Environment Options | SQL Script page.
Drag tables from the explorer tree to add them to the query diagram in the Visual Query Builder.
If you want MySQL Maestro to request login and password on each attempt to connect to the database, check the 'Login prompt before connection' option in the Create Database Profiles Wizard or Database Profile Properties dialog.
To create a new table with the same properties and subobjects as of one of the existing tables, use Database | Duplicate Database Object.
You can hide or show database objects in the explorer tree and Object Manager by using the filter panel available through View | Show Filter Panel.
You can type the beginning of value to locale a record in the data grid quickly.

To find out more on this product visit their site.http://www.sqlmaestro.com

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.