Message Boards Message Boards

1
|
1644 Views
|
1 Reply
|
2 Total Likes
View groups...
Share
Share this post:

Can Mathematica export a MySQL database from a Dataset or entity object?

I have a class in database engineering. I have to create a database app that is based on MySQL. Is there a way to export a Dataset or RelationalDatabase object or EntityStore object in Mathematica to a MySQL database that can be imported into MySQL Server?
I know Mathematica can import SQL databases like RelationalDatabase can import an SQLite database backend object, but is there a way to export a database backend object?
I also think its neat that Mathematica has external evaluate for SQL so maybe this would be helpful for exporting as SQL.

POSTED BY: Peter Burbery

The easiest way to do this is to export the data as CSV and use mysqlimport from the command line to import it. You may have to convert any data that is not purely numeric or text (e.g. Quantity, DateObject, ...) before using Export.

You could also convert your data to a format suitable for SQLImport.

POSTED BY: Rohit Namjoshi
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract