iMy is a full MySQL client for the iPhone. It features the ability to generate complex queries without ever using the keyboard. iMy presents the same interface as MobileCan.

Features:

• Construct complex queries using the built in keyword list and table and field views
• Save queries for future use
• Email query results directly from iMy
• Get server statistics and terminate processes
• Uses Keychain to store passwords securely

Walkthrough

Managing Connections

The Connections screen. The database is in blue on the top line, with the user and host name on the second line.

Adding or editing a connection. Enter the information for each connection. If the password is left blank, there will be a prompt when attempting to connect to the database.

Working with the interface

Connected to the database. Here is the main query screen.

Underneath the query text is a list of keywords that will be inserted into the query when pressed. Pressing the "Tables button" will toggle the button to read "Keywords" will show the tables and fields in the datbase. Selecting a table on the left will update the fields on the right. Click on the "Use Table" or "Use Field" button to insert into either the selected table or field into the query. Press the toggled "Keywords" button to return the keywords.

The toolbar also has a comma button for easy entering of multiple fields in a query.

Pressing the queries button, will bring up a list of saved queries that can be reused. These queries can be saved pressing the Save button, and the text of the query will be saved.

Executing Queries

Viewing an executed query

The first view that is seen after executing a query is the abbreviated field view. The row number is in blue on the top row, and the first three fields are listed below. The fields are listed without field names.

From here, the next 20 records can be retrieved by pressing the "20 more" button.

The current query results can be emailed by pressing the "Email" button. All fields will be put in a tab delimited format and inserted into an email.

Viewing Records

Viewing a record in detail

Selecting a row in abbreviated mode will present the full record in vertical form. If for some reason, the field is longer than can be read on one line, a disclosure indicator will appear, showing the full value of the field.

Server Status

This view presents the Server type and all connected processes to the server. Selecting the server at the top will show more detailed server statistics, such as uptime, etc.

By selecting a process, it is possible to view the full activity, and with proper permissions, kill that process.

Support

See here for iMy support.