Update Mysql table using mym

2 次查看（过去 30 天）
Furqan Hashim
Furqan Hashim 2020-8-20
编辑： Piyush Kumar 2024-10-7
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.

请先登录，再回答此问题。

回答（1 个）

Piyush Kumar
Piyush Kumar 2024-10-7
编辑：Piyush Kumar 2024-10-7
@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.

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by