MySql datainsert/ fastinsert problem

1 次查看(过去 30 天)
Sal
Sal 2015-6-23
Hi all,
When I try to write a single value in one column of my MySql database I retrieve an errror: Error using database/datainsert (line 142) Unable to complete insert operation. Field 'timestamp' doesn't have a default value
The Table of the database is made of several column, the first one is 'timestamp'.
Now Should I write all the columns all togehter to make an insert?
Thanks

回答(1 个)

Titus Edelhofer
Titus Edelhofer 2015-6-23
Hi Sal,
when you write a single entry to one column, then this will add a row to your table, and all the other columns will get their default value. But your timestamp column does not have a default value, therefore you get the error message.
Usually you insert a full row at once into a db ...
Titus

类别

Help CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by