Import CSV File Into MySQL using LOAD DATA INFILE
In this post we are discussing on how to use LOAD DATA INFILE statement to import CSV file into MySQL table. The following statement imports data from c:\tmp\data.csv file into the discounts table. The field of the file is terminated …
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 …