MySQL数据库：网络玩具销售系统数据库PPT.ppt

将玩具代码为“00001”的玩具的mYoyRate增加1 在数据库中删除品牌“Largo” 将种类“Activity”的信息复制到一张新表中(PreferredCategory) 将种类“Dolls”的信息从表Category复制到表(PreferredCategory)中 insert into preferredcategory select a.cbrandid cbrandid2,cbrandname, b.ccategoryid ccategoryid2,ccategory,vdescription,c.* from toybrand a, category b,toys c where a.cbrandid=c.cbrandid and b.ccategoryid=c.ccategoryid and ccategory='Dolls'; 2.1 select * from Toys where cToyName like '%Racer%'; 2.2 select vFirstName from Shopper where vLastName regexp '^s'; 表的