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 …

Map integer to text string in mysql

Posted by on Mar 18, 2014 in MySQL, Php | No comments yet

We can use the functions CASE .. WHEN … to map integer to text string in mysql The example query is as shown below You can also use the ELSE clause to specify a default, e.g.

Remove rows with multiple duplicate columns

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

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

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 …

Load More