Update Mysql table using mym

I am connected to a database using mym. I want to update row based on conditions the sql for that would be

update dbname.dbtable
set Name = 'A' 
where Age = 20 

What is the easiest most elegant way to do that on MATLAB? I want to update table in a MATLAB script where some calculations are being done.

Answer 1

[Piyush Kumar]

@Furqan Hashim,

To update a MySQL table using mym in MATLAB, ensure you have the mym package installed and properly configured.

Check the file exchange link to get details on installation. The same link provides examples for connecting and querying the database.

To achieve the same, you can also use database and sqlupdate functions from the Database Toolbox. Please check the example scripts available in their documentation to get more details.