4. How can we get the number of rows affected by query?

How can we get the number of rows affected by query?

Answer

Number of rows can be obtained by

1
SELECT COUNT(user_id)FROMusers;

All Mysql Questions
Ask your interview questions on mysql

Write Your comment or Questions if you want the answers on mysql from mysql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---