Перетворити MySQL вихід запиту в JSON масив

v2.4.2

• 🐛 Fixed issues: Download pdf is not working

• 🐛 Fixed issues: When importing SQL and inserting multiple lines, there is no space between them.

v2.4.1

• 🐛 Fixed issues: the output of html conversion api is empty

• 🛡️ Escaping single quotes when converting to SQLite

• 🚀 Optimize TableConvert API performance

• 🐛 Fixed issues: Noise when converting into div table

v2.4.0

• ➕ Added support for all converters to the API

• 💰 Added a new paid page with additional features for users who want to upgrade

• 🚀 Made several performance improvements to the app

• 🔒 Enhanced the security of the app by implementing several new security measures

• 📖 Improved the documentation to make it easier for developers to use the API

v2.3.6

• ➕ Added XML importer, TableConvert now supports 10 different import formats

• 💻 Added the option for text alignment in the ASCII and reStructuredText Table

• 🔁 Flipped the logic for Minify AsciiDoc table based on feedback from @Luis

v2.3.5

• 🗑️ Added a button to delete duplicate rows to the Table Editor

• 🗑️ Merge buttons to delete empty rows and columns

• 🐛 Fixed issues: status bar in full screen mode

• 🐛 Fixed issues: The order of the properties of the JSON object is not the same

v2.3.4

• 🔧 The textarea of the Magic generator supports auto-closing brackets

• 🛠️ Optimized Magic: Supports JavaScript code and awk-like syntax

• ➕ Added MySQL Query Output data source

• 🎁 Use backslash `\` to output `{..}` in magic converter

v2.3.3

• 🐛 Fixed that the amount of data is less than the threshold in SQL and DAX converters

• 🔗 Added Line share button

• 🔄 Refactor Template to Magic

• ℹ️ Added tooltip for share button

v2.3.2

• 🔍 SQL generator and DAX generator support automatic inspect data type

• ➕ Added Qlik table generator, The code for Qlik inline loads can now be converted

• ➕ Added DAX table generator, The code for DAX DATATABLE can now be converted

v2.3.1

• 🔨 HTML generator: Replace the `` tag under thead with the `` tag

• 🔨 HTML generator: Added an option to make the first column as headers

• 🎨 Optimized UI and some experience issues

• 🖥️ The editor supports full screen switching

v2.3.0

• ➕ XML Converter can now customize root and row elements

• 🔧 Optimized options for CSV converters

• ➕ Added Firebase list converter and generator

v2.2.3

• Added border style option for LaTeX tables, Thanks to @Daniel for the feedback

• Added text alignment option for LaTeX tables

• Added bold first row option for LaTeX tables

• Added bold first column option for LaTeX tables

• Make tooltip for Border option of Latex converter, more intuitive effect

v2.2.2

• In the SQL converter, support "NULL" as the value of the field

• HTML importer supports reading multiple tables at the same time

• Fixed garbled text in PDF converter when the table contains CJK characters

• Optimize the data source change event to support real-time rendering

v2.2.1

• Added statistics bar to datagrid component

• Added Loading animation

• Simplified notification text

v2.2.0

• Optimize the order of converters to fit most habits

• Fixed the feature of importing split row or join row

• Fixed the template syntax issue when there is an empty row

v2.1.5

• Fixed an issue where pdf could not be downloaded. Thanks to @lpablo611 for the feedback

• In the SQL converter, the line-by-line insertion syntax is used by default. Thanks to @ffortuny for the feedback

• Added the feature of selecting worksheets when uploading Excel. Thanks to @ffortuny for the feedback

• Fixed some issues with importing to Excel

v2.1.4

• Fixed bug with AsciiDoc table converter. Thanks to @kernixski for the feedback

• Added header and compression options to AsciiDoc table generator

• Added "Force separate lines" option to reStructuredText table generator

v2.1.3

• Fixed unicode pipe character in ASCII table generator

• Fixed the problem that the textarea does not refresh

v2.1.2

• Markdown converter supports setting first row as headers

• Bold first line excludes empty strings in Markdown table generator

• Added more ASCII plain text table generators

• Added source code comment support to ASCII table generator

v2.1.1

• JSON converter supports parsing JavaScript objects

• Added more language

• Added Minimal working example (MWE) for LeTeX Table Generator

v2.1.0

• Deutsch language added

• Simplified Chinese language added

• Added i18n support

v2.0.2

• Force text format for Excel

• Refactor IDEA to Template

• Added tooltip for Converter's Options

v2.0.1

• Added Jira Converter and Jira Generator

• Added Textile Converter and Textile Generator

v2.0

• New design is coming, more comprehensive functions, beautiful and easy to use.

• Support switching Dark Mode

• Integrated DataGridXL

• Support search and replace

• Support switch case

• Support drag and drop to upload files

• Support Excel file reading, now you can convert Excel into other tables

• Different input sources have different examples

• More new features are waiting for you to discover

v1.2.7

• Added AsciiDoc Converter, Now you can convert the table to asciidoc code

• Added reStructuredText Converter, Now you can convert the table to reStructuredText code

v1.2.6

• Focus error prompt

• Fixed the "$" and "+" keyword of non-IDEA converters being interpreted

• Import the JSON of a two-dimensional array without unshift

• Automatically trim when using html importer

• Turn off Markdown automatic escape option

• Fixed bug not rendering keys as headers

v1.2.5

• Added SQL importer, you can convert create table sql and insert sql to any format

• Added MediaWiki importer, you can convert MediaWiki table to any format now

• Fixed convert to json if a value contains spaces, these are removed

v1.2.4

• Added PHP Converter, Now you can convert the table to PHP code

• Added Ruby Converter, Now you can convert the table to Ruby code

• Added ASP Converter, Now you can convert the table to ASP code

• Added ActionScript Converter, Now you can convert the table to ActionScript code

• Added BBCode Converter, Now you can convert the table to BBCode

• Added PDF Converter, Now you can convert the table to PDF file

• Added JPEG Converter, Now you can convert the table to Jpeg image file

• Converter tabs now support responsive layout

v1.2.3

• Added specified import type when importing URL

• Added the feature undo/redo、clear and transpose

v1.2.2

• Added export Excel in xlsx format

• Added the feature of converting table into 2D array to JSON converter

• Added the feature of converting table into Column array to JSON converter

• Added the feature of converting table into Keyed array to JSON converter

v1.2.1

• Added `Caption`, `Label`, and `Alignment` options for LatTex converter

• Formatted LaTex table Code

• Added `Table name`, `Generate a create table statement` options for SQL converter

v1.2.0

• Added blog to record help information for this application

• Optimized the main color to make it look comfortable

v1.1.9

• Added a new feature, double-click the output textarea to select all

• Remember the selected cells when adding, deleting, and modifying the table

• Optimize selected cell style

v1.1.8

• Fixed issue: failure when importing from JSON containing fields that are not strings

• Added an ontion to set Markdown to use simple style table

• Added an option to set MediaWiki table to format first row as header

v1.1.7

• Added an option to set Markdown to use compact mode

• Added an option to set the Markdown table Text alignment

• Added MediaWiki converter, now you can easily generate and edit mediawiki tables

• Fixed issue: importing Excel and if there is no entry in a column then when that data is converted to Markdown data is shifted to left columns

v1.1.6

• Refactoring document page

• Support for retaining current data when you redraw the table

• Supports automatic saving of table data

v1.1.5

• Fixed issue: Javascript export CSV encoding utf-8, adding UTF-8 BOM to string

• Beautify pages and components

• Add LaTex converter, Support to convert LaTex to Excel, JSON, CSV, Markdown table, etc

v1.1.4

• Fixed an issue when output text table

• Add a description for the converter, generator and editor

• When importing data, it supports loading local json, csv, md, html and other files

v1.1.3

• Added quotation selector to sql output, you can choose the correct quotes according to the sql engine

• Fixed an issue: Output sync bug

• Added blod first row options for markdown output

• Added center-align text options for markdown output

v1.1.2

• Fixed bug, Ajax falls into an infinite loop when extracting a table from a URL

• Make loading big data smoother

• Fixed an issue where the separator was incorrect when converting csv to a table

• Escape special symbols are selected by default

• Fixed an issue: Split a CSV string ignore commas within double-quotes

v1.1.1

• Added expansion and collapse features, automatically adapt data length

• Added the ability to load data from a URL

• Added an option to the HTMl output, now you can easily convert table to a DIV table

• Optimized the speed of reading content from a URL

v1.1.0

• Added style options to text output, now support output mysql results style, reStructuredText table style and so on

• Added escaping options for Markdown, HTML, XML, and LaTex converters

v1.0.9

• Added JSON converter, now support convert an array of objects to csv, markdown, excel, etc

• Added a options button for the csv tab output, custom delimiters are now supported

• Added minifier, now you can easily compress or minify your JSON, XML, HTML result

v1.0.8

• Added Template converter, you can easily design the output based on your ideas

• Added an options button for the template tab output

• Removed jQuery, compressed pages and improved website speed

v1.0.7

• Added table shortcuts, now you can modify the table content more easily. Thank @Yasuhiko OKADA !

• Optimize arrow shortcuts & streamline default URLs

v1.0.6

• Support for initializing data via URL

• Support table data and URL dynamic binding, now you can easily share data through URL

v1.0.5

• Added the ability to import tables from a URL

• Optimize tab hover style

v1.0.4

• Fixed bug: Empty cell error when importing Excel

• Support for loading examples via `window.location.hash`

• Added a tooltip to the table editor button

v1.0.3

• Added LaTex and Plain Text converter

• Fixed bug: When multiple header fields are the same, the result shows only one

• Optimize table chooser style

• Optimize icon color, Make it softer

• Optimize table chooser, The x axis is row and the y axis is col

v1.0.2

• Added YAML and SQL converter

• Optimize styles and expand available workspaces

• Optimize color contrast

v1.0.1

• Added Excel converter

• Added import capabilities. now you can convert between Excel, CSV/TSV, JSON, and Markdown

• Auto format XML code

• Fixed a bug in XML code generation which result error when the number in the first row of the table appears

v1.0.0

• Support online editing and generating tables

• Support for creating HTML table easily

• Support for converting HTML table to CSV/TSV, JSON, XML, HTML and Markdown table

• Support copy to clipboard

• Support for downloading converted result file

• Added example button