It’s been said time and again that The REAL Programmer automates his job that they are Long Term Life Planners and have Attention to Detail
Here is just an example of ways in which one can automate processes.
I use Seagull Framework for developing faster, secure and feature rich Web based Applications Today, I had to update the Database to fill some blank columns in a table named sgl_permision
I first tried to edit them through the Seagull’s Web based Admin Front end It was taking too long.Then I tried to edit the …

Out of several LAMP/WAMP stack packages available in the market I prefer XAMPP from http://apachefriends.org when Working on a Windows machine for my Development Environment.
The XAMPP for Windows can be downloaded from the following linkhttp://www.apachefriends.org/en/xampp-windows.html
I download/keep the zip archive of the Basic package XAMPP Windows 1.6.4 which has the following components
Apache HTTPD 2.2.6, MySQL 5.0.45, PHP 5.2.4 + 4.4.7 + PEAR + Switch, MiniPerl 5.8.7, Openssl 0.9.8e, PHPMyAdmin 2.11.1, XAMPP Control Panel 2.5, Webalizer 2.01-10, Mercury Mail Transport System v4.01a, FileZilla FTP Server 0.9.23, SQLite 2.8.15, ADODB …

Was searching for the solution to remove the duplicate rows in a column from a mySQL table came across this easy work around.
————————————————————————————This is an extremely quick and painless way to remove duplicate rows (tuples) from a MySQL database table. The best part of it is that it requires no programming or PHP coding whatsoever, it can all be done with three manual SQL queries! Note: this only works on MySQL 3.23 and above. But I have a hard time imagining anyone running an older version than that anyways!
So, there …

MySQL AB :: MySQL 5.0 Reference Manual :: 12.7 Full-Text Search Functions