 |
Data output and data editing is part of table editing | |
|
 |
View, edit, insert and delete data in MySQL tables:
|
| Output options for tables can be viewed and edited. |
| Table data can be edited provided the queried table columns are present in a UNIQUE or PRIMARY index.
The table rows can then be selected and table columns can be edited by double-clicking.
Table rows can then also be edited in a form.
A delete function for table rows is also available. |
| Functions can be selected to edit data. |
| A hexadecimal and binary editor can be selected to edit INTEGER data. |
| ENUM and SET data can be changed by selection forms. |
| Special editors are available for SPATIAL data. |
| Tables can be exported. |
| The window sizes can be changed. |
|
 |
Execute SQL and show result. |
 |
Editing the display options for MySQL data. |
 |
Switch to the data wizard. |
|
 |
Save table data as CSV. |
 |
Save table data as PHP array. |
 |
Save table data as JSON array. |
 |
Save table data as XML script. |
|
 |
Add a new data record to the MySQL table. |
 |
Import data into MySQL table. |
|
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. |
|
Save table 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 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. |
|