kdb icon indicating copy to clipboard operation
kdb copied to clipboard

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

Open HKby opened this issue 5 years ago • 2 comments

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

HKby avatar Mar 06 '19 11:03 HKby

bump

mlerner1 avatar Aug 09 '19 19:08 mlerner1

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');"]

CharlieSkelton-Kx avatar Aug 10 '19 04:08 CharlieSkelton-Kx