Is that away ODBC.k not only load data from MySQL but also push tables to MySQL?

KxSystems / kdb

Companion files to kdb+ and q

https://code.kx.com/q

Apache License 2.0

417 stars 163 forks source link

Is that away ODBC.k not only load data from MySQL but also push tables to MySQL? #13

Open HKby opened 5 years ago

HKby commented 5 years ago

Just want to know if it is possible that kdb+ ODBC.k can insert data / table to MySQL? thanks

mlerner1 commented 4 years ago

bump

CharlieSkelton-Kx commented 4 years ago

yes, although it is limited to submitting the command as text, for example: .odbc.eval[handle;"INSERT INTO mytable(textvalue, start_date, end_date) VALUES('sometextvalue','2018-01-09','2018-09-15');"]