 |
The wizard for history data selection and history deletion is part of table editing | |
|
|---|
 |
Wizard zum Anzeigen und Löschen von History-Daten in System-versionierten MariaDB-Tabellen:
|
| Der Wizard dient zur einfachen Generierung von SQL-Anweisungen zur Daten-Abfrage. |
| Ausgabe-Optionen für Tabellen können angezeigt und bearbeitet werden. |
|
 |
Execute wizard selection as SQL and show result. |
 |
Editing the display options for MySQL data. |
 |
Switch to the SQL Editor. |
|
 |
Save selected data as CSV. |
 |
Save selected data as PHP array. |
 |
Save selected data as JSON array. |
 |
Save selected data as XML script. |
|
| History-Data wizard: |
| SELECT FOR SYSTEM_TIME, | DELETE HISTORY: Selection of the SQL statement. |
|
| Selection: | Selection of history data for SQL statement.
| ALL: | Selection from all dates (HISTORY and CURRENT). |
| AS OF CURRENT_TIMESTAMP: | Selection from current dates (CURRENT). |
| AS OF TIMESTAMP: | Specifies the date and time from which data should be displayed. |
| FROM ... TO ...: | Specifies the date and time between which data should be displayed. |
| BETWEEN ... AND ...: | Specification of expressions (e.g. NOW() - INTERVAL 1 HOUR AND NOW()) between which data should be displayed.. |
|
| Partitions: | Select partitions if the table has been partitioned.
If selected, the Selection for SYSTEM_TIME will be disabled, as not with FOR SYSTEM_TIME from a Partition can be queried. |
| Table Columns: | Available table fields for data selection, data restriction and sorting. |
| WHERE: | Selected selection constraints. |
| ORDER BY: | Selected sortings. |
|
 |
Select table column for data output. |
 |
Select table field for data restriction (WHERE). |
 |
Select table column for ascending sorting. |
 |
Select table column for descending sorting. |
 |
Remove table field from selection. |
|
| History data for system-versioned tables with transaction-specific history: |
 |
| Selection: | Selection of history data for SQL statement.
| ALL: | Selection from all dates (HISTORY and CURRENT). |
| AS OF TRANSACTION: | Entry of transaction number from which to query. |
|
|
| Save queried data as CSV: |
 |
Module part for creating CSV interfaces from MySQL table data:
|
| Excel: | Sets the formatting of the CSV files to Excel default settings. |
| Delimiter: | Selection of the delimiter between the values and with which quotation marks to enclose values. |
| Binary Data: | Setting how binary data should be stored in CSV files.
| Blank field: | Field is transferred empty to CSV files. |
| Hexadecimal: | Values are stored in hexadecimal form in CSV files. |
| Omit: | Binary data is omitted. Also, no field is created in the CSV file. |
|
| Character set: | Character encoding in which the CSV file will be saved. |
| GZip: | Files are saved with GZip compression.
|
| Show CSV: | CSV output is shown as text. |
| Save CSV: | CSV output is saved in database CSV archive. |
| Download CSV: | CSV output will be downloaded as a file. |
|
 |
Settings are saved for further CSV creations. |
 |
Copy text output to clipboard. |
|
| Save queried data as PHP array: |
 |
Module part for generating PHP arrays from MySQL table data:
|
| Field names as array keys: | Table field names are used as keys in the PHP array. |
| Numerical values in quotation marks: | Integer and floating point values are output as strings in the PHP array. |
| Show as text: | PHP array is shown as text in the MyWAY SQL Manager editor. |
| Download: | Downloading PHP array as a file. |
| GZip: | File will be GZip compressed. |
| Create PHP array: | Starts creating the file. |
|
|
Copy text output to clipboard. |
|
| Save queried data as JSON array: |
 |
Module part for creating JSON arrays from MySQL table data:
|
| Formatting: | Formatting JSON output. |
| Mask special characters: | Special characters will be masked for output. |
| Show as text: | JSON array is shown as text in the MyWAY SQL Manager editor. |
| Download: | Downloading JSON array as a file. |
| GZip: | File will be GZip compressed. |
| Create JSON array: | Starts creating the file. |
|
|
Copy text output to clipboard. |
|
| Save queried data as XML file: |
 |
Module part for creating XML script from table data:
|
| Show as text: | XML script is shown as text in the MyWAY SQL Manager editor. |
| Download: | XML script will be downloaded as a file. |
| GZip: | File will be GZip compressed. |
| Create XML script: | Starts creating the file. |
|
|
Copy text output to clipboard. |
|
| History-Daten löschen: |
 |
Selecting DELETE HISTORY to delete history data:
|
| Selection: | Selection of history data for SQL statement. |
| WHERE: | Selected delete restrictions. |
|
The SQL statement with status message and the updated table data appears as output.
|
|
|
Select table column for restriction (WHERE). |
|
Remove table column from selection. |
|
