One Star

Exporting CSV to MYSQl Database

Could someone please let me know if this is a possible scenario?
I would like to export CSV into a MYSQL database. I would like to create database on the fly, create subsequent schema and load data. Please let me know if this makes sense. I have been struggling to get this scenario to work. All I did was to import CSV file, create schema and create MYSQL connection.MY
2 REPLIES
One Star

Re: Exporting CSV to MYSQl Database

Any comments or solutions for this?
Could someone please let me know if this is a possible scenario?
I would like to export CSV into a MYSQL database. I would like to create database on the fly, create subsequent schema and load data. Please let me know if this makes sense. I have been struggling to get this scenario to work. All I did was to import CSV file, create schema and create MYSQL connection.MY
One Star

Re: Exporting CSV to MYSQl Database

use fileinputCSV connect with tMap MySQL output check all parameters, edit schema, action on table set to create if not exist. Should work
if not write problems