How to suppress "Warning: ATTR will be removed in a future release" when update( ) MySQL?
10 views (last 30 days)
Show older comments
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?
0 Comments
Accepted Answer
Luca Ferro
on 9 Jan 2023
Moved: Steven Lord
on 11 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
3 Comments
Luca Ferro
on 11 Jan 2023
Moved: Steven Lord
on 11 Jan 2023
Glad it helped, could you accept my comment as an answer? i've mistakenly written it in the comment section
More Answers (0)
See Also
Categories
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!