Member since 05/22/2008

2 snippets

1046 profile views

1 Comment(s) Posted

View their favorites



first submission:submitting first snipplet

jdbartlett's Recent SnippetsTagged mysql

« 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 503 posted 13 years ago by jdbartlett
Where bad_table is the name of the table containing duplicate rows.
2 331 posted 14 years ago by jdbartlett
« Prev 1 Next »