update

UPDATE

Select a table and hit Update

In order to select desired rows you may use 'WHERE', 'OFFSET' and 'ROWS' parameters. These parameters are also available on the UPDATE page in the command bar above the table fields.

Edit data in spreadsheet

The table is displayed using HTML forms as follows:

TEXT and BLOB columns are displayed as TEXTAREA forms with vertical scrolling enabled.
ENUM columns are displayed as pulldown menus.
All the other column types are displayed as TEXT forms.

Each TEXT and BLOB column has radio button (1) placed beside the column name. Together with the checkboxes (2) it’s used to select text or blob value to be zoomed.

'INSERT' bar placed under the table represents the table columns and is used to insert new rows:

Insert new row

The following buttons resides on the control bar under the table: Update, Insert, Zoom, Delete and Reset. Their names correspond to actions they produce.

Spreadsheet control panel

Update command works only when one or more values of the table were changed. If no value was changed, then the message "Nothing was changed" will be generated.

A separate SQL query will be generated and executed for each row where values was changed. The rows are identified internally using PRIMARY KEY. If the table has no PRIMARY KEY then all the columns of the table take part in the row identification, like this:
... WHERE col1='some data1' AND col2='some data2' ... .
It not always works correctly without unique keys.

LOW PRIORITY and IGNORE options are used in SQL query if the corresponding checkboxes are selected.

In order to enlarge (zoom) a TEXT or BLOB value you must select the corresponding radio button and the checkbox of the row where the desired value belongs. The result of Zooming looks like this:

Zoom Text or Blob Cell

Data inside Zoom window can be edited and updated using 'Update' button. If 'Zoom Out' is pressed then all changes are ignored and the previous page will be displayed.
To delete some rows select them using checkboxes and click DELETE.
LOW PRIORITY checkbox can be used with DELETE command.
Column list is used to select the columns to be displayed.
If 'Preview' checkbox is selected, any query, generated by the program is displayed before execution.

Previous

TOC

Next

[Home] [Products] [Screenshots] [Demo] [Manual] [Account] [Order] [Contact us]