这篇博客主要探讨了多个SQL查询语句的使用，包括根据ID获取详细信息、模糊匹配、条件过滤等操作。文章深入浅出地解析了如何在数据库中进行数据检索和过滤，强调了LIKE运算符和CONCAT函数在SQL查询中的应用。
1
4
5 SELECT xsmc from xs where xsdm=#{id}6
7
10
11 SELECT xsmc from xs where xsdm=#{id}12
13
14
15
16 SELECT xsdm,xsmc from xs17
18
19
20
21 SELECT xsdm,xsmc from xs22 WHERE xsmc like concat('%',#{zzz},'%')23
24
25
26 SELECT xsdm,xsmc from xs27 where xsmc LIKE concat('%',#{name},'%') AND xsdm >#{id}28
29
30
31 SELECT xsdm,xsmc from xs32 where xsmc LIKE concat('%',#{resultName},'%') AND xsdm >#{resultId}33
34
35
36 SELECT xsdm,xsmc from xs37 where xsmc LIKE concat('%',#{0},'%') AND xsdm >#{1}38
39
40
41 select xsdm,xsmc from xs42
43
44 and xsmc like concat('%',#{name},'%')45
46
47 and xsdm>#{id}48
49
50
51
52
53 select xsdm,xsmc from xs54
55
56 10">
57 xsmc like concat('%',#{name},'%');58
59 60">
60 xsdm>30;61
62
63 xsdm=164
65
66
67
68
69
70
71 select * from xs72 0">
73 where xsdm in74
75 #{myid}76
77
78
79
80
81 select * from xs82 0">
83 where xsdm in84
85 #{myid}86
87
88
89
90
91 insert INTO xs(xsdm,xsmc) VALUES92 0">
93
94 (#{user.id},#{user.name})95
96
97
98
99
100 select * from xs101 0">
102 where xsdm in103
104 #{user.id}105
106
107
491
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
