How to suppress "Warning: ATTR will be removed in a future release" when update( ) MySQL?
10 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Simon
am 9 Jan. 2023
Verschoben: Steven Lord
am 11 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?
0 Kommentare
Akzeptierte Antwort
Luca Ferro
am 9 Jan. 2023
Verschoben: Steven Lord
am 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 Kommentare
Luca Ferro
am 11 Jan. 2023
Verschoben: Steven Lord
am 11 Jan. 2023
Glad it helped, could you accept my comment as an answer? i've mistakenly written it in the comment section
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Database Toolbox finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!