mysql values not updating

I have written a code to update values in matlab as shown below

sqlquery = strcat('update attend set attendence=attendence+1 where id=',int2str(idupdate)); disp(sqlquery); curs = exec(conn,sqlquery); curs=fetch(curs);

It update my value but the updated value is not committed. When I try to commit there is no change.

Tell me if there is anything to change. I am using the native odbc driver to connect.

Answer 1

[Rajanya]

Hi @Arvind Iyer,

I understand that you are trying to update values in a table corresponding to a database in MySQL. Given that the connection is established properly with the correct database, one of the reasons for this could be that the ‘AutoCommit’ property of the connection object is set to ‘off’.

I tried with an example table and was able to reproduce the same. After setting the proper connections and setting the ‘AutoCommit’ property manually to ‘on’, the problem was solved and the changes were permanently committed to the database table 'my_test'. The table contains two columns, 'id' and 'name'.

conn = database('database_name', 'user_name', 'password', ...
    'Vendor', 'MySQL', 'Server', 'localhost', 'PortNumber', 3306);

You can visit the related documentation pages for ‘commit’ and ‘update’ by the following commands:

doc commit
doc update

Hope this helps!