MySQL Forums :: Workbench - SQL Browser, Editor, Refactor :: get rows affected message after insert/update action
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.
For example:
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?
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.
For example:
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?
| Subject | Views | Written By | Posted |
|---|---|---|---|
| get rows affected message after insert/update action | 560 | Judy Whiteside | 11/28/2012 03:44PM |
| Re: get rows affected message after insert/update action | 286 | Mike Lischke | 12/04/2012 02:36AM |
| Re: get rows affected message after insert/update action | 255 | Judy Whiteside | 12/04/2012 07:21AM |
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.
© 2013, Oracle Corporation and/or its affiliates