Does Mysql have an equivalent to @@ROWCOUNT like in mssql?

by

For SELECTs you can use the FOUND_ROWS construct (documented here):

SELECT SQL_CALC_FOUND_ROWS something FROM your_table WHERE whatever;
SELECT FOUND_ROWS( ) ;

which will return the number of rows in the last SELECT query (or if the first query has a LIMIT clause, it returns the number of rows there would’ve been without the LIMIT).

For UPDATE/DELETE/INSERT, it’s the ROW_COUNT construct

INSERT INTO your_table VALUES (1,2,3);
SELECT ROW_COUNT();

which will return the number of affected rows.

More Related Contents:

  1. Can a stored procedure/function return a table?
  2. Is it possible to have a default parameter for a mysql stored procedure?
  3. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  4. Join vs. sub-query
  5. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  6. Natural Sort in MySQL
  7. MySQL get row position in ORDER BY
  8. Subqueries vs joins
  9. Can I pass column name as input parameter in SQL stored Procedure
  10. MySQL Results as comma separated list
  11. MySQL unknown column in ON clause
  12. Connect By Prior Equivalent for MySQL
  13. Stored procedure or function expects parameter which is not supplied
  14. MySQL not using indexes with WHERE IN clause?
  15. SQL: Find the max record per group [duplicate]
  16. Group by month and year in MySQL
  17. MySQL: Transactions vs Locking Tables
  18. Call a stored procedure with another in Oracle
  19. Select TOP X (or bottom) percent for numeric values in MySQL
  20. How to return the output of stored procedure into a variable in sql server
  21. Execute Immediate within a stored procedure keeps giving insufficient priviliges error
  22. MySQL select where column is not empty
  23. Hamming distance on binary strings in SQL
  24. Renaming foreign-key columns in MySQL
  25. MySQL GROUP BY behavior
  26. What does collation mean?
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. sql pulling a row for next or previous row of a current row
  29. Row Rank in a MySQL View
  30. Select Rows with Maximum Column Value group by Another Column

Leave a Comment