Import CSV File Into MySQL using LOAD DATA INFILE

Posted by on Feb 27, 2015 in General, MySQL, Php | 2 Comments

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

Posted by on Nov 14, 2012 in MySQL, Php | No comments yet
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

Posted by on Nov 14, 2012 in MySQL, Php | No comments yet

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