sql server - Matlab fastinsert error -
i have simple table in sqlserver database, simsqltable. column head are:
index, del_date, name i have table in matlab mytbl, 1 row:
num deldate myname --- ------- ------ 1 '07-02-2015 00:00:00.0' 'jenz' mycolnames = {'index', 'del_date', 'name'} i use fastinsert this:
fastinsert(conn, 'simsqltable', mycolnames, mytbl) but error:
error using database/fastinsert (line 90) variable fields , insert fields not match.
how resolve this?
fastinsert queries database datatypes of columns. causes problems reserved keywords. try use back-tick ` in mysql or " in transact-sql quote keyword index.
mysql:
mycolnames = {'`index`', 'del_date', 'name'} transact-sql:
mycolnames = {'"index"', 'del_date', 'name'}
Comments
Post a Comment