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 [...]