mysql的预准备语句_Perl DBI(MySQL)在预准备语句中放置单引号而不是实际参数

我正在尝试做一个简单的查询作为准备好的声明,但没有成功.这是代码：

package sqltest;

use DBI;

DBI->trace(2);

my $dbh = DBI->connect('dbi:MysqL:database=test;host=***;port=3306','the_username','****');

my $prep = 'SELECT me.id,me.session_data,me.expires FROM sys_session me WHERE me.id = ?';

$dbh->{RaiseError} = 1;

my $sth = $dbh->prepare($prep);

$sth->bind_param(1,'session:06b6d2138df949524092eefc066ee5ab3598bf96');

$sth->execute;

DBI::dump_results($sth);

MysqL服务器响应”’附近的语法错误.

DBI跟踪的输出显示

-> bind_param for DBD::MysqL::st (DBI::st=HASH(0x21e35cc)~0x21e34f4 1 'session:06b6d2138df949524092eefc066ee5ab3598bf96') thr#3ccdb4

Called: dbd_bind_ph

[...]

>parse_params statement SELECT me.id,me.expires FROM sys_session me WHERE me.id = ?