Main Features
Browse and Manipulate MySQL database from your iPhone!
Just input host, username and password, you can easily browse and manipulate information on MySQL database server.
Using the touch panel, you can manupilate many things from server information to table data.
- Advanced setting for connecting to database server
- Easy to browse server administration items
- Create, edit, drop objects
- Alter table data (insert,update,drop)
- Easy way to generate and execute SQL statement
1.【Advanced setting for connecting to database server】
- Enables you to set up details of connection to database server when you log-in.
<Menu for Advanced Setting>
| Default database |
| Character set |
| Collating sequence |
| Connect timeout |
| Auto reconnection |
| Compression |
| Save password |
‐Screen shots‐ (on-Mouse for Zooming, click for opening a new window.）
- 1. Log in screen
- 2. Advanced setting
Top
2.【Easy to browse server administration items】
- Quickly browse current server information such as server setting values and logs.
(
※ only FLUSH is executable)
<a list of viewable items>
| Server Administration |
| Server System Variables |
| Status |
| User |
| FLUSH |
| Log |
‐Screen shots‐ (on-Mouse for Zooming, click for opening a new window.）
Top
3.【Create, edit, drop Objects.】
- Create, edit and drop objects from the list in each object section.
<Editable Objects>
※Some objects are editable with GUI, ohters use SQL statement.
| Database |
| Table |
| Index |
| View |
| Procedure/Function |
| Trigger |
| Event |
‐Screen shots‐ (on-Mouse for Zooming, click for opening a new window.）
Top
4.【Alter table data (insert/update/drop)】
- Alter table data directly from your iPhone.
Display the table data and tap the column you want to edit. You can easily update,insert as well as drop table data on the display.
‐Screen shots‐ (on-Mouse for Zooming, click for opening a new window.）
Top
5.【Generate and execute SQL statements with input assist】
- Able to specify column on GUI screen to create SQL statements
Once you have connected to the database then you can execute SQL statements.
On the SQL execute screen, there are lists of DML・DDL・DCL (*1) which you can use in the SQL language,
and it also has an input assist function and predictively displays what might comes next.
You can just select from the displayed options and easily generate SQL statements.
