Query Overview
Previous  Top  Next

queryMyCon makes creating queries a real breeze. A query pane includes a full syntax highlighted, multi-sql statement capable, autoparameter, autocorrection, autoproposal, autocompletion SQL Editor. Data is displayed in a full data Grid capable of display, filtering, sorting, grouping your data and presenting it to you in either a Grid View or Card View. Clicking the Text toolbar button will refetch all your data from MySQL and present all columns as text string fields exactly as MySQL returns it, i.e. MyCon will not convert the data to integers or enums with picklists and editors will be plain string editors for all columns. SQL statements are logged for you by the Logger just before it is actually send to the MySQL server. Other capabilities of the Query pane includes, printing your data in multiple formats, creating a Backup/Dump script from your sql statements or even to schedule your script to run periodically on your computer as well as scheduling a backup script to be generated periodically. You can give your Editor focus using Ctrl+I, your Grid using Ctrl+G and your Logger using Ctrl+L. You can also change masses of options on your grid's behaviour and layout, see Grid Options.