UPDATE BookInfo SET B_SalePrice=B_MarketPrice*0.7
WHERE 'MysQL=
(SELECT BT_Name FROM BookType WHERE BookInfo.BT_ID-BookType.BT_ID);
上为例题,如下图
UPDATE BookInfo SET B_SalePrice=B_MarketPrice*0.7
WHERE 'MysQL=
(SELECT BT_Name FROM BookType WHERE BookInfo.BT_ID-BookType.BT_ID);
上为例题,如下图