MySql datainsert/ fastinsert problem

2 views (last 30 days)
Sal
Sal on 23 Jun 2015
Answered: Titus Edelhofer on 23 Jun 2015
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

Answers (1)

Titus Edelhofer
Titus Edelhofer on 23 Jun 2015
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

Community Treasure Hunt

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

Start Hunting!