#眉標=MySQL、InnoDB、MyISAM #副標=MySQL管理技巧 #大標=避免交易中斷與檔案同時更新引發爭議 #作者=文／圖 葉建榮 ==========<反灰>============ create table innodbproducts ( productid int(11) default null, productname varchar(40) default null, unitprice double default null, unitsinstock smallint(6) default null ) engine=innodb default charset=utf8; ====================================== ==========<反灰>============ create table myisamproducts ( productid int(11) default null, productname varchar(40) default null, unitprice double default null, unitsinstock smallint(6) default null ) engine=myisam default charset=utf8; ====================================== ==========<反灰>============ mysql> show table status from test; +----------------+--------+------ | Name | Engine | Version | Row_format +----------------+--------+------ | innodbproducts | InnoDB | 10 | Compact | myisamproducts | MyISAM | 10 | Dynamic ====================================== ==========<反灰>============ insert into innodbproducts values(1,'產品1',500,100); insert into innodbproducts values(2,'產品2',600,200); insert into innodbproducts values(3,'產品3',700,300); ====================================== ==========<反灰>============ 交易 ======================================