Write data to MySql
Posted: Wed Feb 11, 2015 6:39 am
Hi,
I would like to write data to a MySQl workbench table without destroying its structure.
I tried the following:
However, this fills the whole table and changes field data types.
Is there a controlled way (preferably in SQL like an insert) to insert values into a MySQL database besides the workaround in http://forums.eviews.com/viewtopic.php?f=3&t=29. If not I fear to have imlpement it in form of the suggested workaround :(
I would like to write data to a MySQl workbench table without destroying its structure.
I tried the following:
Code: Select all
wfsave(type=odbc) dsn=MYDSN;uid=USERNAME;pwd=PASSWORD;database=MYDATABASE "insert into estimates (field1, field2) values ('",date,"',",value,")" Is there a controlled way (preferably in SQL like an insert) to insert values into a MySQL database besides the workaround in http://forums.eviews.com/viewtopic.php?f=3&t=29. If not I fear to have imlpement it in form of the suggested workaround :(