Perl插入MySQL中双引号的问题 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Programming - 葵花宝典

Perl插入MySQL中双引号的问题

Perl插入MySQL中双引号的问题# Programming - 葵花宝典

L*r2007-12-15 08:12

1 楼

用如下语句给MySQL插值，当$words[0]= " 的时候，perl脚本出错：
比如这行数据: ! ) " 60252
my $rows = $dbh->do(qq{INSERT INTO GoogleDVD_all (word_0,word_1,word_2,N1)
VALUES ("$words[0]","$words[1]","$words[2]","$words[3]")});
DBD::mysql::db do failed: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near '60252")' at line 1 at delimiter_changer4.pl line 15, line
31.
请赐教，谢谢

c*t2007-12-15 08:12

2 楼

用单引号

to
line

【在 L******r 的大作中提到】

: 用如下语句给MySQL插值，当$words[0]= " 的时候，perl脚本出错：
: 比如这行数据: ! ) " 60252
: my $rows = $dbh->do(qq{INSERT INTO GoogleDVD_all (word_0,word_1,word_2,N1)
: VALUES ("$words[0]","$words[1]","$words[2]","$words[3]")});
: DBD::mysql::db do failed: You have an error in your SQL syntax; check the
: manual that corresponds to your MySQL server version for the right syntax to
: use near '60252")' at line 1 at delimiter_changer4.pl line 15, line
: 31.
: 请赐教，谢谢

l*92007-12-15 08:12

3 楼

you need place-holder
my $rows = $dbh->do(qq{INSERT INTO GoogleDVD_all (word_0,word_1,word_2,N1)
VALUES (?,?,?,?)}, @words[0,1,2,3]);
(untested)..
recommend you "use DBIx::Simple" which makes DBI interface much easier..

to
line

【在 L******r 的大作中提到】

L*r2007-12-15 08:12

4 楼

谢谢，还有问题
在插入如下行时出错：
$ ' 1550166
DBD::mysql::db do failed: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near '1550166')' at line 1 at delimiter_changer5.pl line 19,
line 10000000.
$ '0 13616
DBD::mysql::db do failed: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near '0','13616')' at line 1 at delimiter_changer5.pl line

【在 l*******9 的大作中提到】

: you need place-holder
: my $rows = $dbh->do(qq{INSERT INTO GoogleDVD_all (word_0,word_1,word_2,N1)
: VALUES (?,?,?,?)}, @words[0,1,2,3]);
: (untested)..
: recommend you "use DBIx::Simple" which makes DBI interface much easier..
:
: to
: line

L*r2007-12-15 08:12

5 楼

DBI::db=HASH(0x812d770)->do(...): attribute parameter '!' is not a hash ref
at delimiter_changer4.pl line 17, line 31.

N1)
the
syntax

【在 l*******9 的大作中提到】