©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
Edit SQL data on MySQL, MariaDB tables

Edit SQL data on MySQL and MariaDB tables

Table data Data output and data editing is part of table editing
View and edit data in MySQL tables
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 Execute SQL and show result.
Data options Editing the display options for MySQL data.
SQL editor Switch to the data wizard.
CSV interface Save table data as CSV.
PHP interface Save table data as PHP array.
JSON interface Save table data as JSON array.
XML interface Save table data as XML script.
Add data record Add a new data record to the MySQL table.
Import data Import data into MySQL table.
Save table data as CSV:
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.
Save settings Settings are saved for further CSV creations.
Copy text Copy text output to clipboard.
Save table data as PHP array:
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 Copy text output to clipboard.
Save table data as JSON array:
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 Copy text output to clipboard.
Save table data as XML script:
Save table 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 Copy text output to clipboard.
Information on selecting data from MySQL tables: mysql.com and mariadb.com
Information on manipulating data in MySQL tables: mysql.com and mariadb.com
Updated: 2023-09-16ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer