How to suppress "Warning: ATTR will be removed in a future release" when update( ) MySQL?

4 次查看(过去 30 天)
Everytime I use the update( ) function to update a row in a MySQL table, the warning message is displayed
Warning: ATTR will be removed in a future release
My program was updating thousands of rows in a MySQL table, and the warning is displayed thousands of times. As a result, I couldn't see other warning messages or my own prompt message.
What should I do to suppress that warning specifically? Or should I replace update( ) with another function?

采纳的回答

Luca Ferro
Luca Ferro 2023-1-9
移动:Steven Lord 2023-1-11
to suppress a specific warning you need to find it's identifier using:
w=warning('query','last'); %store last warning as a 2 field struct (identifier,status)
wid=w.identifier; %store identifier
and then turn it off with:
warning('off',wid); %set warning to off
in a similar fashion you can turn it on again if needed.
For the warning itself i wouldn't worry too much, still you could try to run an update query from matlab instead of using the update function.:
SQLdbconn=database('SQLDatabaseName','username','password'); %make connection to database
query= ['UPDATE table_name SET column1=value WHERE condition']; %create query as string
data=fetch(SQLdbconn,query) %execute update query and fetch results
  3 个评论
Luca Ferro
Luca Ferro 2023-1-11
移动:Steven Lord 2023-1-11
Glad it helped, could you accept my comment as an answer? i've mistakenly written it in the comment section
Simon
Simon 2023-1-11
移动:Steven Lord 2023-1-11
I actually was wanting to do the 'accept', but I couldn't find the button to click.
Could you repost your answer as 'Answer this question?' Thanks.

请先登录,再进行评论。

更多回答(0 个)

类别

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

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by