How to find duplicated values in MySQL (or/and probably any other RDBM)

As an example I take one real (almost) table I have in my db. Structure is very simple : Table name: “words”, field “filename” name of the file and “words” just some information about each file. +—————–+———————+ |   filename     |     words         | +—————–+———————+ Suddenly we had a few files with exactly same name and […]

Posted on February 16, 2009 at 14:55 by admin · Permalink · Leave a comment
In: English, sql · Tagged with: , ,

Installing PHP & Apache on Vista

Everybody, who tried it, knows – installing PHP5 & Apache2.2 on Vista might be a little bit tricky (on Linux it might take a lot less time sometimes). Let’s assume we have Administrator access and latest versions of Apache. In my case it’s apache_2.2.10-win32-x86-no_ssl.msi & (note: I am not using .msi or anything similar […]

Posted on November 7, 2008 at 09:58 by admin · Permalink · 2 Comments
In: English, Fighting the system · Tagged with: , , , , , , ,