get rows affected message after insert/update action
Posted by: Judy Whiteside
Date: November 28, 2012 03:44PM
Mysql Workbench 5.2.44 CE running on Win7 pro x64
Mysql is 5.1.45-community
After running an INSERT or UPDATE, I need to capture the complete message as shown in the Action Output message panel.
775 row(s) affected Records: 597 Duplicates: 304 Warnings: 0
However using Select row_count() only gives the 775 number
show warnings; gives no output at all (expected, as there are no warnings)
The manual seems to say that show Warnings will give some information messages, but apparently that is only referring to warning-information-messages, not general information of any kind.
I particularly need the Duplicates number after running ON DUPLICATE KEY UPDATE work.
How can I get this number, or this text string to parse?
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.