Archive for 2008

Tegan and Sara – I know I know I know

Posted July 25, 2008 * Comments(0)

Two cats eating

Posted July 25, 2008 * Comments(1)

Two cats eating

Drinking cat

Posted July 25, 2008 * Comments(0)

Drinking cat

Sweet dreams

Posted July 25, 2008 * Comments(0)

Sweet dreams

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)

« Previous Page