请教数组输出

Bisn

我想将数组 @array = (2 4 6 8); 以 2:4:6:8 的形式录到 MySQL 数据库中，该怎么写的？

yangcen22

join ':', @array;

hfahe

use DBI;
use join or $" = ':'

ynchnluiti

1. 
   
2. my @array = qw(2 4 6 8);
   
3. 
   
4. my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost","","", {'RaiseError' => 1});
   
5. 
   
6. my $rows = $dbh->do("INSERT INTO mytable(value) VALUES ('". join(":", @array)."')");
   
7. 
   
8. $dbh->disconnect();
   

复制代码