1.16 练习题: 把good表中商品名为'诺基亚xxxx'的商品,改为'HTCxxxx', 提示:大胆的把列看成变量,参与运算,甚至调用函数来处理 . substring(),concat()
mysql> select goods_id,goods_name from goods; +----------+------------------------------+ | goods_id | goods_name | +----------+------------------------------+ | 1 | kd876 | | 4 | 诺基亚n85原装充电器 | | 3 | 诺基亚原装5800耳机 | | 5 | 索爱原装m2卡读卡器 | | 6 | 胜创kingmax内存卡 | | 7 | 诺基亚n85原装立体声耳机hs-82 | | 8 | 飞利浦9@9v | | 9 | 诺基亚e66 | | 10 | 索爱c702c | | 11 | 索爱c702c | | 12 | 摩托罗拉a810 | | 13 | 诺基亚5320 xpressmusic | | 14 | 诺基亚5800xm | | 15 | 摩托罗拉a810 | | 16 | 恒基伟业g101 | | 17 | 夏新n7 | | 18 | 夏新t5 | | 19 | 三星sgh-f258 | | 20 | 三星bc01 | | 21 | 金立 a30 | | 22 | 多普达touch hd | | 23 | 诺基亚n96 | | 24 | p806 | | 25 | 小灵通/固话50元充值卡 | | 26 | 小灵通/固话20元充值卡 | | 27 | 联通100元充值卡 | | 28 | 联通50元充值卡 | | 29 | 移动100元充值卡 | | 30 | 移动20元充值卡 | | 31 | 摩托罗拉e8 | | 32 | 诺基亚n85 | +----------+------------------------------+ 31 rows in set (0.00 sec) mysql> select goods_id,goods_name from goods where goods_name like '诺基亚%'; +----------+------------------------------+ | goods_id | goods_name | +----------+------------------------------+ | 4 | 诺基亚n85原装充电器 | | 3 | 诺基亚原装5800耳机 | | 7 | 诺基亚n85原装立体声耳机hs-82 | | 9 | 诺基亚e66 | | 13 | 诺基亚5320 xpressmusic | | 14 | 诺基亚5800xm | | 23 | 诺基亚n96 | | 32 | 诺基亚n85 | +----------+------------------------------+ 8 rows in set (0.03 sec) mysql> select goods_id,substring(goods_name,4) from goods where goods_name like '诺基亚%'; +----------+-------------------------+ | goods_id | substring(goods_name,4) | +----------+-------------------------+ | 4 | n85原装充电器 | | 3 | 原装5800耳机 | | 7 | n85原装立体声耳机hs-82 | | 9 | e66 | | 13 | 5320 xpressmusic | | 14 | 5800xm | | 23 | n96 | | 32 | n85 | +----------+-------------------------+ 8 rows in set (0.00 sec) mysql> select goods_id,concat(substring(goods_name,4)) from goods where goods_na me like '诺基亚%'; +----------+---------------------------------+ | goods_id | concat(substring(goods_name,4)) | +----------+---------------------------------+ | 4 | n85原装充电器 | | 3 | 原装5800耳机 | | 7 | n85原装立体声耳机hs-82 | | 9 | e66 | | 13 | 5320 xpressmusic | | 14 | 5800xm | | 23 | n96 | | 32 | n85 | +----------+---------------------------------+ 8 rows in set (0.02 sec) mysql> select goods_id,concat('htc',substring(goods_name,4)) from goods where go ods_name like '诺基亚%'; +----------+---------------------------------------+ | goods_id | concat('htc',substring(goods_name,4)) | +----------+---------------------------------------+ | 4 | htcn85原装充电器 | | 3 | htc原装5800耳机 | | 7 | htcn85原装立体声耳机hs-82 | | 9 | htce66 | | 13 | htc5320 xpressmusic | | 14 | htc5800xm | | 23 | htcn96 | | 32 | htcn85 | +----------+---------------------------------------+ 8 rows in set (0.01 sec) mysql>

我的微信
这是我的微信扫一扫