 |
The wizard for data selection and data processing is part of table processing | |
|
|---|
 |
Wizard for displaying, editing, inserting and deleting data in MySQL tables:
|
| The wizard is used to easily generate SQL statements. |
| Output options for tables can be viewed and edited. |
|
 |
Execute wizard selection as SQL and show result. |
 |
Editing the display options for MySQL data. |
 |
Switch to the SQL Editor. |
|
 |
Save table data as CSV. |
 |
Save table data as PHP array. |
 |
Save table data as JSON array. |
 |
Save table data as XML script. |
|
| Data wizard: |
| SELECT, UPDATE, INSERT, REPLACE, DELETE: | Selection of the SQL statement. |
| Options: | Enable options of the SQL statement. |
| Table columns: | Available table columns for data selection, data restriction and sorting. |
| WHERE: | Selection constraints. |
| ORDER BY: | Selected sortings. |
|
 |
Select table column for data output. |
 |
Select table column for data restriction (WHERE). |
 |
Select table column for ascending sorting. |
 |
Select table column for descending sorting. |
 |
Remove table column from selection. |
|
| Save table 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. |
|
| Generate PHP array from table data: |
 |
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 table 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 table data as XML script: |
 |
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. |
|
| Data manipulation with data wizard: |
 |
Select UPDATE to change data:
|
| Options: | Enable update statement options. |
| Table columns: | Available table columns for data manipulation and restriction. |
| WHERE: | Selected update restrictions. |
|
The SQL statement with status message and the updated table appears as output.
|
|
|
Select table column for data manipulation. |
|
Select table column for restriction (WHERE). |
|
Remove table column from selection. |
|
