How to get the table name with a required column name in MySQL using query

While working on a project we had a big database which contains more than 250 tables. I wanted to get the table name containing a column say “Column A”. We can do it easily with a query. Say now we have a database called as “Test_Database” with lot of tables and columns. Now I want…

Read More

How to find the next set of records after a specified one in MYSQL

Greetings Of The Day! While we were working with web services using PHP and Mysql  for an android application, we had a use case to retrieve and show a set of data to one user and remaining set of data to other user based on the login details. Application had Master and Partner users. Consider…

Read More