MySQL: return updated rows

by

Apparently mysql does have something that might be of use, especially if you are only updating one row.

This example is from: http://lists.mysql.com/mysql/219882

UPDATE mytable SET
mycolumn = @mycolumn := mycolumn + 1
WHERE mykey = 'dante';

SELECT @mycolumn;

I’ve never tried this though, but do let me know how you get on.

More Related Contents:

  1. How do you set a default value for a MySQL Datetime column?
  2. Compare two MySQL databases [closed]
  3. MySQL – Trigger for updating same table after insert
  4. Storing image in database directly or as base64 data?
  5. Implementation of Levenshtein distance for mysql/fuzzy search?
  6. Is MySQL breaking the standard by allowing selecting columns that are not part of the group by clause?
  7. MySQL – Operand should contain 1 column(s)
  8. How to get the difference in years from two different dates?
  9. Restore table structure from frm and ibd files
  10. Can a number be used to name a MySQL table column?
  11. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  12. mysql pivot/crosstab query
  13. UNION query with codeigniter’s active record pattern
  14. When to use MongoDB or other document oriented database systems? [closed]
  15. MySQL grant all privileges to database except one table
  16. mysql stored procedure that calls itself recursively
  17. MySql views performance [closed]
  18. Restore the mysql database from .frm files
  19. When to use NULL in MySQL tables
  20. How to get number of rows affected, while executing MySQL query from bash?
  21. What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL?
  22. Detecting locked tables (locked by LOCK TABLE)
  23. How does MySQL Auto Increment work?
  24. MySQL CURRENT_TIMESTAMP on create and on update
  25. mysql – Dynamic column alias
  26. Access denied after setting user’s password with SHA256 in phpMyAdmin
  27. connecting to a docker-compose mysql container denies access but docker running same image does not
  28. MySQL’s lower_case_table_names won’t change
  29. #1214 – The used table type doesn’t support FULLTEXT indexes
  30. Optimistic locking in MySQL

Leave a Comment