
Specialist III
2008-12-14
09:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
179 Views
2 Replies

Specialist III
2010-05-25
09:19 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
179 Views

Contributor III
2010-05-26
10:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
if not write problems
179 Views
