perl程序问题？菜

leaper

我的一个程序。
  拷到/tmp目录下，
  #chmod +x mysql.pl
  #./mysql.pl

结果如下，为何？？
bash: ./msyql.pl: No such file or directory


要如何执行。请指教>;>;>;

deathcult

里面肯定是写了#!/bin/sh     

改成#!/usr/bin/perl
(perl的位置)

apile

misspelling....
mysql.pl not msyql.pl

deathcult

leaper

1. #!/usr/bin/perl -w
   
2. use strict;
   
3. use DBI;
   
4. 
   
5. use DBI;
   
6. 
   
7. my $dbh = DBI->;connect('DBI:mysql:test','root','') or die "无法连接数据库: " . DBI->;errstr;
   
8. 
   
9. my $sth = $dbh->;prepare(q{INSERT INTO add (name) VALUES ('aaa') });
   
10. 
    
11. $sth->;execute()
    
12. 
    
13. $dbh->;disconnect;

复制代码

我想在test数据库中的表add中插入一条name='aaa'记录。
结果运行不对

1. [root@leap mail]# ./mysql.pl
   
2. Scalar found where operator expected at ./mysql.pl line 16, near ")
   
3. 
   
4. $dbh"
   
5.         (Missing semicolon on previous line?)
   
6. syntax error at ./mysql.pl line 16, near ")
   
7. 
   
8. $dbh"
   
9. Execution of ./mysql.pl aborted due to compilation errors.

复制代码

请问错在哪了@@@

deathcult

$sth->;execute() 后面加上 ";"

deathcult

use DBI;多了一个，

use strict; 暂时去掉吧。容易产生更多的疑问。

leaper

改上上面的两个错，现在出现以下的信息

1. 
   
2. [root@leap mail]# ./mysql.pl
   
3. install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at (eval 1) line 3.
   
4. Perhaps the DBD::mysql perl module hasn't been fully installed,
   
5. or perhaps the capitalisation of 'mysql' isn't right.
   
6. Available drivers: ExampleP, Proxy.
   
7. at ./mysql.pl line 6
   
8. [root@leap mail]#

复制代码

deathcult

“Perhaps the DBD::mysql perl module hasn't been fully installed, ”


有DBD-mysql模块么？

leaper

谢谢楼主。搞定了，

3Q3Q3Q3Q3Q3Q3Q3Q3Q3Q3Q3Q3Q3Q3Q3Q3Q