It’s been quite some-time since I wrote a blog – sorry guys didn’t get any time to write. But today I got a good one, a place where you find info about sql-joins in a simple/neat explanation. Today I am going to talk about SQL Joins yes, there are quite a bit of types: Join, [...]
All posts in category Database
(My)SQL Joins – JOIN, CROSS, INNER, OUTER (LEFT, RIGHT, FULL)
Posted by Rakesh Sankar on December 25, 2010
http://rakesh.sankar-b.com/2010/12/25/mysql-join-cross-inner-outer-left-right-full/
INSTALL (SETUP) DEBIAN Linux OS for Development/Production – A Day with SETUP
Today I am going to talk about only installation of tools/apps required for LINUX Server. I have chosen DEBIAN, since it makes you intelligent . Okay, cool, now? First thing you have to buy a hosting space, there are quite a good people who provide this service – see here. OKAY – Now let’s say you [...]
Posted by Rakesh Sankar on September 10, 2010
http://rakesh.sankar-b.com/2010/09/10/install-setup-debian-os-server-machine-for-web-development/
MySQL Unsigned INT to Signed INT – A Valid Performance For Index
You know by making an INT typeunsigned you achieve 50% improvement in your select query - can’t believe it? Yes so do I until I tried the tip by myself. Today I am going to talk about a simple tip on MySQL - create-tables which will improve the performance of the SELECT SQL query. Let us consider the following table structure: CREATE TABLE customer [...]
Posted by Rakesh Sankar on August 25, 2010
http://rakesh.sankar-b.com/2010/08/25/mysql-unsigned-int-to-signed-int-performance-tips-index/
learnMORE
STAYtune
