MySQL Forums
Forum List  »  MySQL Workbench

MySQL Workbench CSV Export
Posted by: Brad Clarke
Date: July 07, 2019 06:31PM

Hi,

I have a forms plugin on my website that writes data to a MySQL database. I'd like to be able to export the table data to CSV but the plugin writes information about the forms fields and it's values into a single column.

For example. If I entered my first name "Brad", last name "Clarke" and "Apples" into the form than it writes this:

[{"value":"Brad","clean":false,"visible":"true","invalid":false,"cellOrder":2,"id":11,"isUpdated":true},{"value":"Clarke","clean":false,"visible":"true","invalid":false,"id":12,"isUpdated":true},{"value":"Apples","clean":false,"visible":"true","invalid":false,"id":24,"isUpdated":true}

It writes the above example into a single column..

here is the DDL for the table:

CREATE TABLE `wp_nf3_object_meta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL,
`key` longtext COLLATE utf8mb4_general_ci NOT NULL,
`value` longtext COLLATE utf8mb4_general_ci,
`meta_key` longtext COLLATE utf8mb4_general_ci,
`meta_value` longtext COLLATE utf8mb4_general_ci,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci


Is there any way to separate the values and export them to CSV?

Thanks

Brad

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Workbench CSV Export
156
July 07, 2019 06:31PM
29
August 06, 2019 04:39AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.