Remove rows with multiple duplicate columns
Some times we need to remove rows with multiple duplicate columns as shown in the table below,See the last two rows with same values. ID college courses 183 24 102 151 24 52 155 24 66 179 24 66 With …
How to find the duplicate values in MySQL
In this post we are discussing about how to find the duplicate values in MySQL. There are a lot of scenarios in which we found this post helpfull.We can find the duplicate values in in MySQL table using the SELECT Query This …
Store Arrays in Database Php
When working with arrays its necessary to store an array in a MySQL field. Unfortunately, there is no way to directly pass in an array as a parameter.. in this case we have to use the function serialize and unserialize …
Load More
