Prepare statement in MySQL doesn't work

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
zenon
Forum Commoner
Posts: 42
Joined: Fri Jan 23, 2009 1:41 pm

Prepare statement in MySQL doesn't work

Post by zenon »

Hello.

I have MySQL 4.1 and i'm trying to use:

Code: Select all

PREPARE stmt_name FROM 'SELECT * FROM hello WHERE id= ?';
SET @test_parm = 1;
EXECUTE stmt_name USING @test_parm;
DEALLOCATE PREPARE stmt_name;
but unfortunately i get no result.

I want to use this way for MySQL injection.

Any help please?
Post Reply