Problem: Finding records in Table b that do not match records in Table a This sort of problem may arise when you need to scrub a file against another or run a duplicate scan on a file against another to weed out any duplicates that may exist prior to doing whatever it is you need [...]
So I have been working with Scribus for the last few days for a project at work. Being on Linux, I always look for software that let me do what needs to be done that are opensource, Scribus ended up being the perfect desktop publishing solution that works on Linux. If you are looking for [...]
In case you ever need to convert one of those flash videos that you find all over the web these days (for example on youtube.com), you can use your linux box very easily to do so. But first, download the .flv (flash video) file from the website. To do that, use “unplug” addon for Mozilla [...]
Problem: Find records that match within two tables, TableA and TableB. Solution: Use a simple SELECT statement with a defined WHERE clause Lets assume that TableA and TableB have a field called “Phone” which contains the phone number of the clients and these numbers are obviously stored in a unique index. So what we are [...]
Problem: TableA contains a customer database TableB contains new names that you want to match against your customer database and remove all the names that are already customers. Solution: Use “LEFT JOIN” property of mysql to carry out the task. Lets assume that TableA and TableB have a field called “Phone” which contains the phone [...]
If you have a SB Live Platinum 5.1 with the IR Drive in front and you got it when the CD that came with the sound card had only Win 98 drivers, well then you are like me! Everytime you need to do a reinstall of Win XP (and you know, this thing happens more [...]