r00t.gr

Programming and more

Entries for the ‘MySQL’ Category

test

sdfsdfsdf

Disable stopwords in mysql Full text index

Disable stopwords in mysql Full text index if you didn’t know what full text index for mysql is google it. It makes searches for text much faster than using “where text like ‘%keywod1%’ AND text like ‘%keyword2%’. (at least 100 times faster) That trick saved me in a when I had an overloaded server. Anyway, […]

MySQL – How to ignore Duplicate Entry errors

I has trying to modify a table, add a Unique combination of fields that i forgot about. So I run: ALTER TABLE `files` ADD UNIQUE ( `sid` , `season` , `episode` );ALTER TABLE `files` ADD UNIQUE ( `sid` , `season` , `episode` ); Unfortunatelly I had some duplicate entries with that, and I get a […]