(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0)
PDO::exec — 执锟斤拷一锟斤拷 SQL 锟斤拷洌拷锟斤拷锟斤拷锟斤拷锟接帮拷锟斤拷锟斤拷锟斤拷
$statement
) : intPDO::exec() 锟斤拷一锟斤拷锟斤拷锟斤拷锟侥猴拷锟斤拷锟斤拷锟斤拷锟斤拷执锟斤拷一锟斤拷 SQL 锟斤拷洌拷锟斤拷锟斤拷艽锟斤拷锟斤拷影锟斤拷锟斤拷锟斤拷锟斤拷锟�
PDO::exec() 锟斤拷锟斤拷锟揭伙拷锟� SELECT 锟斤拷锟斤拷蟹锟斤拷亟锟斤拷锟斤拷锟斤拷锟斤拷锟节筹拷锟斤拷锟斤拷只锟斤拷要锟斤拷锟斤拷一锟轿碉拷 SELECT 锟斤拷洌拷锟斤拷钥锟斤拷锟绞癸拷锟� PDO::query()锟斤拷锟斤拷锟斤拷锟斤拷要锟斤拷锟斤拷锟斤拷蔚锟斤拷锟戒，锟斤拷锟斤拷 PDO::prepare() 锟斤拷准锟斤拷一锟斤拷 PDOStatement 锟斤拷锟斤拷锟斤拷 PDOStatement::execute() 锟斤拷锟斤拷锟斤拷洹�
PDO::exec() 锟斤拷锟斤拷锟斤拷锟睫改伙拷删锟斤拷 SQL 锟斤拷锟接帮拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫伙拷锟斤拷锟接帮拷锟斤拷锟叫ｏ拷锟斤拷 PDO::exec() 锟斤拷锟斤拷 0锟斤拷
锟剿猴拷锟斤拷锟斤拷锟杰凤拷锟截诧拷锟斤拷值
FALSE锟斤拷锟斤拷也锟斤拷锟杰凤拷锟截碉拷同锟斤拷 FALSE 锟侥非诧拷锟斤拷值锟斤拷锟斤拷锟侥讹拷 锟斤拷锟斤拷锟斤拷锟斤拷锟铰斤拷锟皆伙拷取锟斤拷锟斤拷锟斤拷息锟斤拷应使锟斤拷
===
锟斤拷锟斤拷锟�锟斤拷锟斤拷锟皆此猴拷锟斤拷锟侥凤拷锟斤拷值锟斤拷
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 PDO::exec() 锟侥凤拷锟斤拷值锟角诧拷锟斤拷确锟侥ｏ拷锟斤拷锟斤拷锟斤拷影锟斤拷锟斤拷锟斤拷为 0 锟斤拷锟斤拷锟结导锟铰碉拷锟斤拷 die() 锟斤拷
<?php
$db->exec() or die(print_r($db->errorInfo(), true));
?>
Example #1 锟斤拷锟斤拷一锟斤拷 DELETE 锟斤拷锟�
锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷 WHERE 锟街撅拷锟� DELETE 锟斤拷锟缴撅拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
<?php
$dbh = new PDO('odbc:sample', 'db2inst1', 'ibmdb2');
/* 删锟斤拷 FRUIT 锟斤拷锟捷憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 */
$count = $dbh->exec("DELETE FROM fruit WHERE colour = 'red'");
/* 锟斤拷锟截憋拷删锟斤拷锟斤拷锟斤拷锟斤拷 */
print("Deleted $count rows.\n");
?>
锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�
Deleted 1 rows.