Using WinMySQL Professional

Insert a record

Only accessible when connected and a table is active and when the grid is switched to table editor mode (to be sure, perform a «Table management>Reload» with «Ctrl-Z»), the «Record>Insert» submenu allows a user to add a record in the current table. Obviously, he must have the «Can INSERT» privilege granted.

How to insert a record ?

To insert a record, invoke the «Record>Insert» submenu clicking on it or use the «Ctrl-Ins» which is really more ergonomic. Then, a blank line is inserted on the top of the grid and a zoom window relating the first column is raised. In this zoom window, you may enter a value for the first column and click on the «Ok» button. The zoom window then moves on the right to wait that you enter a value for the second column ... It does so until the last column. After a value entered for the last column, WinMySQL Professional may asks a confirmation to commit the line into the table if the («Record>Delete/Update/Insert confirmation» submenu is checked (default is unchecked).

Note :Sometimes, it is possible that the zoom menu raises first not relating the first column or skips several columns. This cases happen when the skippeds column doesn't require any data from a user : for example, a column containing an ID with auto incrementation or a timestamp, etc ...or when the manual entering is impossible such as blobs.

How to update a record ?

To update a record, be sure that the grid is switched in table editor mode, put the cursor on the record field which must be updated. Then, strike the «Enter» key : the Zoom window raises with the field value edited. Change it and click on the «Ok» button.

Because of the RowID mechanism not yet supported by MySQL®, if the table doesn't have any primary key, it is possible that several identical lines may be affected. If the table is in this case, WinMySQL Professional will notity if the «Record>No primary key warning» submenu is unchecked.

Zoom window description

The zoom window consists in a zoomed cell which it has the same properties as which are applied on the grid with the «Output grid>Grid font setup» but with bigger characters ; on the title bar, WinMySQL Professional displays the properties of the current column (to prevent the incompatible data type inputs). You also can find the «Ok», «Reset» and «Cancel» button which meaning is obvious.

Less obvious, a small checkbox called «Auto focus Ok button» allows, when checked, to give automatically focus to the «Ok» button, one second after a user has stopped entering characters. The target of this checkbox is to allow an input burst without using the «Tab» key.