Create/Modify/Drop/Rename a Table
Previous  Top  Next


To create a new table

tablenewAs easy as pie! Simply select the Tables folder just below your Databases folder, right click and type in your new table name in the Add box and press Enter. You will be prompted to confirm. MyCon will create a new table with the name you specified and the table will have a default ID autoinc column set as the primary key of your table. You can change the column and primary key using the steps in the next section. led-triangle-amber You must have the necessary privileges on the MySQL server to successfully perform the creation, see your MySQL manual for more details and also have a look at Security Overview of MyCon, how you can setup these security privileges for different MySQL users.



To modify an existing table


tablecolumnsSelect your table in the Folders pane, right click it and click on Properties. This will open the Table Properties window, where you can add, modify and delete columns. Also you can add and delete existing table indexes, setup the default table data view grid options and see general MySQL information of the table in this window.




To rename an existing table


To rename a table, just select it in the Folders pane, then press F2 or click again in it's name. Change the name and press enter and confirm your choice for the new table name. led-triangle-green This also renames any configuration and query files associated with the table.



To drop an existing table


Dropping a table is as easy as selecting it in the Folders Pane, then pressing Ctrl+Del or right click and click Delete. You will be prompted to confirm. led-triangle-red you will loose all your table structure and data in the process if confirmed. Your MyCon files, i.e. queries, scripts, etc will remain in tact.