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

  • Number of rows can be obtained in MySQL by using the query SELECT ROW_COUNT();
  • Explanation:

     


Previous Papers

Model Tests

Current Affairs

Question Answers

Related Question & Answers

Write a query to count the number of rows of a table in MySQL.

What is the difference between BLOB and TEXT?

What are the column comparisons operators?

How do you backup a database in MySQl?

How can one restart SQL Server in single user or minimal configuration modes?

Related Practice Tests

MySQL Interview Questions for Freshers
Categories
AndroidC programmingC++ programmingCloud ComputingComputerComputer System ArchitecureData BaseData StructureInternet & Social MediaJava programmingManual TestingMS OfficeMySQLNetworkingOperating SystemPHPProgrammingSoftware EngineeringSoftware Testing
How can we get the number of rows affected by query?
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges