Managing MySQL tables

To manage MySQL tables, you must first open a MySQL tab, connect to a server, and select a database. To learn how to do these things, see Managing MySQL databases.

To select a table from the current database, click on its name in the left sidebar of the MySQL tab. The table's structure or content will be displayed in the work area of the tab, depending on the setting of the Structure / Content switch, located at the bottom of the tab.

To edit the table's structure or content, double-click the table cell you wish to edit, and make your changes. When you deselect the row, or move to another row, Coda will attempt to commit your changes to the server.

In both structure and content modes, buttons are available at the bottom of the MySQL tab to add, duplicate, and delete rows in the table. A reload button is also available.

In content mode, your table content is displayed in pages, so the entire table does not need to be loaded at once. The pagination controls in the lower-right of the MySQL tab allow you to move forward or backward by one page, or jump to a specific page by number.

To change the number of content rows displayed per page, choose Coda > Preferences > General and edit the value for MySQL rows per page .

You can add or delete a table by clicking the + or - buttons at the bottom of the table list. A reload button is also available.

In content mode, you can perform simple filtering of data using the filter bar, located at the top of the MySQL tab. To filter table content, choose the column you wish to filter on from the first popup, choose a comparison operator from the second popup, then enter a value for the comparison and click Filter .

See also: Performing a custom query