[MXS-4143] Able to export columns data with table structure for only those selected columns like sqlYog Created: 2022-05-20 Updated: 2024-01-11 Resolved: 2024-01-11 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | maxgui |
| Affects Version/s: | None |
| Fix Version/s: | 24.02.0 |
| Type: | New Feature | Priority: | Major |
| Reporter: | Naresh Chandra | Assignee: | Duong Thien Ly |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
|
|||||||||||||||||||||||||
| Issue Links: |
|
|||||||||||||||||||||||||
| Sub-Tasks: |
|
|||||||||||||||||||||||||
| Sprint: | MXS-SPRINT-194, MXS-SPRINT-195, MXS-SPRINT-196, MXS-SPRINT-197, MXS-SPRINT-199 | |||||||||||||||||||||||||
| Description |
|
Actual Table in the Database server: CREATE TABLE `slow_log` ( If we write a select query from the SQL editor for the above table like below. SELECT sql_text, COUNT(SUBSTR(sql_text,1,60)) AS execution_count, user_host, AVG(query_time),MIN(query_time),MAX(query_time), rows_sent, rows_examined FROM mysql.slow_log WHERE db='test_db' Then we should be able to export the sql file with the customized table structure and data.. After running and exporting the above query then if we open the .sql file like below. Below is the custom table structure and data. create table `slow_log` ( We should be able to export the .sql file with the below options with the select/deselect custom columns,. Attaching the screenshot for your reference. |