續: http://ssorc.tw/rewrite.php/read-999.html

my $sql = "UPDATE table_name SET value = 123 WHERE id = 1 AND name = 'cross'";

上面看來語法並沒有什麼異樣

但存取 access 的話需要

my $sql = "UPDATE [table_name] SET value = 123 WHERE id = 1 AND name = 'cross'";

沒錯，不一樣的地方是要在 tables_name 加上 [] 中括號才行啊

use strict;
use DBI;

# mdb 資料庫
my $mdb = 'C:\access.mdb';

# SQL 語法
my $sql = 'select * from notifications';

# 連線到資料庫
my $dbh = DBI->connect("dbi:ODBC:driver=microsoft access driver (*.mdb);dbq=$mdb");

# 執行 SQL 語法
my $sth = $dbh->prepare("$sql");
$sth->execute || die " Could not execute SQL statement ... maybe invalid?";

# 顯示出結果
while (my @row = $sth->fetchrow_array()){ 
    print "@row\n";
}