1.16 练习题:把good表中商品名为’诺基亚xxxx’的商品,改为’HTCxxxx’,

MySQL
1
2
3
4
1.16 练习题:
把good表中商品名为'诺基亚xxxx'的商品,改为'HTCxxxx',
提示:大胆的把列看成变量,参与运算,甚至调用函数来处理 .
substring(),concat()

MySQL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
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>

 

weinxin
我的微信
把最实用的经验，分享给最需要的读者，希望每一位来访的朋友都能有所收获！
avatar

Comment

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: