14,970
edits
Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
Mysql management tools
(Mysql management tools) |
|||
| Line 97: | Line 97: | ||
* Add '''escape character''' escape the column value if contains the '''enclosure character''' | * Add '''escape character''' escape the column value if contains the '''enclosure character''' | ||
* Remove return symbol<ref>[http://stackoverflow.com/questions/1504962/how-to-remove-new-line-characters-from-data-rows-in-mysql trim - How to remove new line characters from data rows in mysql? - Stack Overflow]</ref>: <pre>SELECT REPLACE(REPLACE(REPLACE(`my_column`, '\r\n', ' '), '\n', ' '), '\r', ' ') </pre> | * Remove return symbol<ref>[http://stackoverflow.com/questions/1504962/how-to-remove-new-line-characters-from-data-rows-in-mysql trim - How to remove new line characters from data rows in mysql? - Stack Overflow]</ref>: <pre>SELECT REPLACE(REPLACE(REPLACE(`my_column`, '\r\n', ' '), '\n', ' '), '\r', ' ') </pre> | ||
== Mysql management tools == | |||
''$'' [https://www.sqlprostudio.com/# SQLPro Studio - macOS database management UI] v. 1.0.127 for {{Mac}} | |||
* Import format: Import CSV file into table | |||
* Export format: Export query result set as CSV, Json, XML | |||
* Engine supported: MySQL, MSSQL, Oracle, PostgreSQL | |||
== References == | == References == | ||