Introduction To SQL_CALC_FOUND_ROWS and Found_Rows

In Mysql there are lot of built in functions which can be used to easily manipulate mysql results. But we tend to write lot of queries and code to do those tasks due to lesser knowledge in those built in functions. In this post I am going to explain a mysql function which needs to be used in lot of practical situations. Lets start learning Found_Rows function..

Tutorial Contents

• How To Use Found_Rows Function
• Code Explanation
• Practical Usage

Why We Need To Concatenate Rows Into Single Column

This post shows you the need of concatenating rows Into single column using real world example. Consider a situation where users place orders on items in a shop. So inorder to store the required details we need 3 tables user,orders and order_items as shown in the tables below..

Tutorial Contents

• Practical Situation Which Requires Concatenate Rows Into Single Column
• How To Use SQL Group Concat Function

Why Do We Need to Clear Database Table Data In production environment we test the web applications by inserting test data to the database tables. Once all the testing is completed we need to install our web application on the real server environment. So we have to remove all test data and install a fresh [...]