How to suppress "Warning: ATTR will be removed in a future release" when update( ) MySQL?
9 views (last 30 days)
Show older comments
Simon on 9 Jan 2023
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 on 9 Jan 2023
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
More Answers (0)
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!