Each MySQL database consists of a number of tables. MyCon allows you to Create/Modify/Drop/Rename Tables, you can also Backup/Dump a specific Table or all a database's Tables' structure and data. Each table in a database is represented with a folder in your Folders section just below the connection's/Databases/Database/Tables folder. When you right click a Table, you have two primary options, Open and Properties.
| · |  If you click Open, you will get a Grid View window containing your data and functionality to export/copy data from your table. 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. You can also create easy and fast reports of your table data and customize your look and feel of your data as well as see your data in Grid or Card View formats. Or use the Blob Editor on your binary blob columns to view and change your pictures or data in the column. Your table data window also contains a sql Logger.
|
| · |  If you click Properties, you will get the your table's property sheet window, which contains four tabs, where you can customize your table's structure, i.e. columns, also your tables indexes, change grid options for displaying, filtering, limiting your data and Table Information which presents you with MySQL information in your table.
|