Archive for June, 2008

We are sinking!

Posted June 25, 2008 * Comments(0)

I think there’s a spy among us

Posted June 23, 2008 * Comments(0)

I think there's a spy among us

MySQL: passing limits as stored procedure parameters

Posted June 23, 2008 * Comments(1)

Unfortunately MySQL 5 (at least 5.0.15) does not allow using variables or procedure parameters with LIMIT.

Here is a workaround where SQL statement is generated inside stored procedure:

CREATE PROCEDURE GetList (limitStart INT, limitCount INT)
BEGIN
 
SET @SQL = CONCAT('SELECT ID, Name FROM `User`
LIMIT ', limitStart, ', ', limitCount);
 
PREPARE query FROM @SQL;
EXECURE query;
DEALLOCATE PREPARE query;
 
END;

IKEA job interview

Posted June 16, 2008 * Comments(0)

Business hours

Posted June 16, 2008 * Comments(0)