Browsing articles in "MySql"
Mar
7
2013

US States MYSQL Dump Quick Copy

USAMap50StatesMapNames

Copy and paste MYSQL Query in phpmyadmin to generate a table and store all US state with names & abbreviations.

Jun
8
2012

Remove duplicate rows from a mySQL db table

mysql1

To remove the all the duplicate entries from a particular mysql table, use the below mysql query : Step : 1

What the above query does is, it will create a new table with the filtered data (all duplicate entries were deleted). Note : replace the whole  [COLUMN TO remove duplicates BY] with your column name Step 2: After that delete the old table

Step 3 : rename the new table