Export/Copy data from a Table or Query

Export/Copy data from a Table or Query

Previous Top Next

There are several methods and formats you can get data from your tables or queries.

A child can do it - Drag & Drop/Copy & Paste

By far the easiest method is to select your tables/queries/scripts/reports in your folder tree view (using Ctrl and Shift with your mouse to control which tables to selectively add to the selection), then simply drag and drop your tables/queries/etc to the destination MySQL server or database. If you hold Ctrl just before you drop your tables you will make a copy of the tables. MyCon will prompt you to make sure if you want to "move" your tables and thus if you wish to drop them in the source database. MyCon will also prompt you as to if you would like only the table structure or it's data copied/moved as well. You can also do single tables for example, by rightclicking it in the folder view, then click Copy Folder, select your destination (for example your Tables folder of another database or even another server), then right click again and pick Paste Folder.

The easiest method - Clipboard

When you have your table or query data in a grid or card format, you can simply select records or even just specific cells using Shift+Arrow Keys. Once selected you can press Ctrl+C (Copy) to put your data in the Clipboard. You can now paste your data into your favourite external program like Excel, Notepad, etc.

A little harder - Grid Report

tablegridpdf

Again, either just select cells or records after having hidden unwanted columns and filtering out unwanted data. Then click on the Grid menu, click Print or pick a specific format for your data. You can choose from PDF, Excel, HTML, XML, Text and Clipboard. Then follow the relevant instructions depending on your choice. If you just click Print your data will be printed to the printer of your choice. Use the Preview, Setup and Designer options to change your data format, headings, styles and options.

Another format - SQL
tablefolders

If you prefer your data in SQL format, i.e. create and insert statements, you can simply click the Backup button in your data Grid View. It will automatically fire up MyRun, which in turn will use your current filter and data limits to generate an SQL script containing the table structure information, i.e. Create statement, and Insert statements capable of replicating your data. The source and resulting sql scripts will be automatically added to your Folders' Queries and Scripts respectively. To see these, just wait for MyRun to finish and then refresh both your Queries and Scripts folder.

Way harder - New Report

You can also choose to make use of MyCon's extensive reporting facilities to graphically design your source data, create a new report and then you can also print it into any number of formats. To start a new report, right click your Reports/Templates folder and click Open, now click Design. The Report Designer will open, Click the Data Tab, then File-New from the Report Designer menu and use the wizard to guide you in setting up your source data. Then click the Design Tab and again File-New from the Report Designer menu, again use the wizard in guiding you in setting up your initial outline. Remember to save your template, which will be added as a new template below your Reports/Templates folder. When you are finished you can click the Print button and either Print your report or pick from the many formats listed on the drop down menu.