User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Computer Science and Software Design section within the Software Development category of DaniWeb, a massive community of 391,775 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,437 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Computer Science and Software Design advertiser:
Views: 3045 | Replies: 0
Reply
Join Date: Dec 2004
Location: Fort Bragg, NC
Posts: 189
Reputation: mikeSQL is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 2
mikeSQL's Avatar
mikeSQL mikeSQL is offline Offline
Junior Poster

MySQL Maestro

  #1  
Dec 20th, 2004
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
AddThis Social Bookmark Button
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb Computer Science and Software Design Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the Computer Science and Software Design Forum

All times are GMT -4. The time now is 4:52 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC