<?php $database = mysql_connect( "localhost","root", "helloworld" ); mysql_select_db( 'test', $database ); mysql_query( 'set names utf-8' ); mysql_query( 'START TRANSACTION' ); $sql = "update tbl_test set name=wuhuiran where id=1"; // 这里将执行失败,因为name是varchar类型的 mysql_query( $sql ); if( mysql_errno() ) { mysql_query( 'ROLLBACK' ); exit(mysql_error()); } $sql = "insert into tbl_test (name) values ('psli')"; mysql_query( $sql ); if( mysql_errno() ) { mysql_query( 'ROLLBACK' ); exit( mysql_error() ); } mysql_query( 'COMMIT' ) or exit( mysql_error() ); mysql_close( $database ); ?>