Profile
Achievement
jdbartlett's Recent SnippetsTagged mysql
- All /
« Prev 1 Next »
When you forget to "SET NAMES utf8", you'll probably end up with a bunch of latin1 data in your utf8 column. This query fixes that, CONVERTing the existing data to its correct collation.
4
852
posted 15 years ago by jdbartlett
Where bad_table is the name of the table containing duplicate rows.
2
584
posted 16 years ago by jdbartlett