function.res
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:9k
源码类别:

MySQL数据库

开发平台:

Visual C++

  1. --------------
  2. select 1+1,1-1,1+1*2,8/5,8%5,mod(8,5),mod(8,5)|0,-(1+1)*-2,sign(-5)
  3. --------------
  4. 1+1 1-1 1+1*2 8/5 8%5 mod(8,5) mod(8,5)|0 -(1+1)*-2 sign(-5)
  5. 2 0 3 1.60 3 3 3 4 -1
  6. --------------
  7. select floor(5.5),floor(-5.5),ceiling(5.5),ceiling(-5.5),round(5.5),round(-5.5)
  8. --------------
  9. floor(5.5) floor(-5.5) ceiling(5.5) ceiling(-5.5) round(5.5) round(-5.5)
  10. 5 -6 6 -5 6 -6
  11. --------------
  12. select abs(-10),log(exp(10)),ln(exp(10)),log2(65535),log(2,65535),exp(log(sqrt(10))*2),pow(10,log10(10)),rand(999999),rand()
  13. --------------
  14. abs(-10) log(exp(10)) ln(exp(10)) log2(65535) log(2,65535) exp(log(sqrt(10))*2) pow(10,log10(10)) rand(999999) rand()
  15. 10 10.000000 10.000000 2.000000 2.000000 10.000000 10.000000 0.1844 0.7637
  16. --------------
  17. select least(6,1.0,2.0),greatest(3,4,5,0)
  18. --------------
  19. least(6,1.0,2.0) greatest(3,4,5,0)
  20. 1.0 5
  21. --------------
  22. select 1 | (1+1),5 & 3,bit_count(7)
  23. --------------
  24. 1 | (1+1) 5 & 3 bit_count(7)
  25. 3 1 3
  26. --------------
  27. select 0=0,1>0,1>=1,1<0,1<=0,strcmp("abc","abcd"),strcmp("b","a"),strcmp("a","a")
  28. --------------
  29. 0=0 1>0 1>=1 1<0 1<=0 strcmp("abc","abcd") strcmp("b","a") strcmp("a","a")
  30. 1 1 1 0 0 -1 1 0
  31. --------------
  32. select "a"<"b","a"<="b","b">="a","b">"a","a"="A","a"<>"b"
  33. --------------
  34. "a"<"b" "a"<="b" "b">="a" "b">"a" "a"="A" "a"<>"b"
  35. 1 1 1 1 1 1
  36. --------------
  37. select "abc" like "a%", "abc" not like "%d%", "ab" like "a%", "a%" like "a%","abcd" like "a%b_%d"
  38. --------------
  39. "abc" like "a%" "abc" not like "%d%" "ab" like "a%" "a%" like "a%" "abcd" like "a%b_%d"
  40. 1 1 0 1 1
  41. --------------
  42. select "Det h鋜 鋜 svenska" regexp "h[[:alpha:]]+r", "aba" regexp "^(a|b)*$"
  43. --------------
  44. "Det h鋜 鋜 svenska" regexp "h[[:alpha:]]+r" "aba" regexp "^(a|b)*$"
  45. 1 1
  46. --------------
  47. select !0,NOT 0=1,!(0=0),1 AND 1,1 && 0,0 OR 1,1 || NULL, 1=1 or 1=1 and 1=0
  48. --------------
  49. !0 NOT 0=1 !(0=0) 1 AND 1 1 && 0 0 OR 1 1 || NULL 1=1 or 1=1 and 1=0
  50. 1 1 0 1 0 1 1 1
  51. --------------
  52. select IF(0,"ERROR","this"),IF(1,"is","ERROR"),IF(NULL,"ERROR","a"),IF(1,2,3)|0,IF(1,2.0,3.0)+0
  53. --------------
  54. IF(0,"ERROR","this") IF(1,"is","ERROR") IF(NULL,"ERROR","a") IF(1,2,3)|0 IF(1,2.0,3.0)+0
  55. this is a 2 2.0
  56. --------------
  57. select 2 between 1 and 3, "monty" between "max" and "my",2=2 and "monty" between "max" and "my" and 3=3
  58. --------------
  59. 2 between 1 and 3 "monty" between "max" and "my" 2=2 and "monty" between "max" and "my" and 3=3
  60. 1 1 1
  61. --------------
  62. select 2 in (3,2,5,9,5,1),"monty" in ("david","monty","allan"), 1.2 in (1.4,1.2,1.0)
  63. --------------
  64. 2 in (3,2,5,9,5,1) "monty" in ("david","monty","allan") 1.2 in (1.4,1.2,1.0)
  65. 1 1 1
  66. --------------
  67. select 'hello',"'hello'",'""hello""','''h''e''l''l''o''',"hel""lo",'hel'lo'
  68. --------------
  69. hello 'hello' ""hello"" 'h'e'l'l'o' hel"lo hel'lo
  70. hello 'hello' ""hello"" 'h'e'l'l'o' hel"lo hel'lo
  71. --------------
  72. select concat("monty"," was here ","again"),length("hello"),ascii("hello")
  73. --------------
  74. concat("monty"," was here ","again") length("hello") ascii("hello")
  75. monty was here again 5 104
  76. --------------
  77. select locate("he","hello"),locate("he","hello",2),locate("lo","hello",2)
  78. --------------
  79. locate("he","hello") locate("he","hello",2) locate("lo","hello",2)
  80. 1 0 4
  81. --------------
  82. select left("hello",2),right("hello",2),substring("hello",2,2),mid("hello",1,5)
  83. --------------
  84. left("hello",2) right("hello",2) substring("hello",2,2) mid("hello",1,5)
  85. he lo el hello
  86. --------------
  87. select concat("",left(right(concat("what ",concat("is ","happening")),9),4),"",substring("monty",5,1))
  88. --------------
  89. concat("",left(right(concat("what ",concat("is ","happening")),9),4),"",substring("monty",5,1))
  90. happy
  91. --------------
  92. select concat("!",ltrim("  left  "),"!",rtrim("  right  "),"!")
  93. --------------
  94. concat("!",ltrim("  left  "),"!",rtrim("  right  "),"!")
  95. !left  !  right!
  96. --------------
  97. select insert("txs",2,1,"hi"),insert("is ",4,0,"a"),insert("txxxxt",2,4,"es")
  98. --------------
  99. insert("txs",2,1,"hi") insert("is ",4,0,"a") insert("txxxxt",2,4,"es")
  100. this is a test
  101. --------------
  102. select replace("aaaa","a","b"),replace("aaaa","aa","b"),replace("aaaa","a","bb"),replace("aaaa","","b"),replace("bbbb","a","c")
  103. --------------
  104. replace("aaaa","a","b") replace("aaaa","aa","b") replace("aaaa","a","bb") replace("aaaa","","b") replace("bbbb","a","c")
  105. bbbb bb bbbbbbbb aaaa bbbb
  106. --------------
  107. select replace(concat(lcase(concat("THIS"," ","IS"," ","A"," ")),ucase("false")," ","test"),"FALSE","REAL")
  108. --------------
  109. replace(concat(lcase(concat("THIS"," ","IS"," ","A"," ")),ucase("false")," ","test"),"FALSE","REAL")
  110. this is a REAL test
  111. --------------
  112. select soundex(""),soundex("he"),soundex("hello all folks")
  113. --------------
  114. soundex("") soundex("he") soundex("hello all folks")
  115. H000 H4142
  116. --------------
  117. select password("test")
  118. --------------
  119. password("test")
  120. 378b243e220ca493
  121. --------------
  122. select 0x41,0x41+0,0x41 | 0x7fffffffffffffff | 0,0xffffffffffffffff | 0
  123. --------------
  124. 0x41 0x41+0 0x41 | 0x7fffffffffffffff | 0 0xffffffffffffffff | 0
  125. A 65 9223372036854775807 -1
  126. --------------
  127. select interval(55,10,20,30,40,50,60,70,80,90,100),interval(3,1,1+1,1+1+1+1),field("IBM","NCA","ICL","SUN","IBM","DIGITAL"),field("A","B","C"),elt(2,"ONE","TWO","THREE"),interval(0,1,2,3,4),elt(1,1,2,3)|0,elt(1,1.1,1.2,1.3)+0
  128. --------------
  129. interval(55,10,20,30,40,50,60,70,80,90,100) interval(3,1,1+1,1+1+1+1) field("IBM","NCA","ICL","SUN","IBM","DIGITAL") field("A","B","C") elt(2,"ONE","TWO","THREE") interval(0,1,2,3,4) elt(1,1,2,3)|0 elt(1,1.1,1.2,1.3)+0
  130. 5 2 4 0 TWO 0 1 1.1
  131. --------------
  132. select format(1.5555,0),format(123.5555,1),format(1234.5555,2),format(12345.5555,3),format(123456.5555,4),format(1234567.5555,5),format("12345.2399",2)
  133. --------------
  134. format(1.5555,0) format(123.5555,1) format(1234.5555,2) format(12345.5555,3) format(123456.5555,4) format(1234567.5555,5) format("12345.2399",2)
  135. 2 123.6 1,234.56 12,345.556 123,456.5555 1,234,567.55550 12,345.24
  136. --------------
  137. select database(),user()
  138. --------------
  139. database() user()
  140. monty
  141. --------------
  142. select null,isnull(null),isnull(1/0),isnull(1/0 = null),ifnull(null,1),ifnull(null,"TRUE"),ifnull("TRUE","ERROR"),1/0 is null,1 is not null
  143. --------------
  144. NULL isnull(null) isnull(1/0) isnull(1/0 = null) ifnull(null,1) ifnull(null,"TRUE") ifnull("TRUE","ERROR") 1/0 is null 1 is not null
  145. NULL 1 1 1 1 TRUE TRUE 1 1
  146. --------------
  147. select 1 | NULL,1 & NULL,1+NULL,1-NULL
  148. --------------
  149. 1 | NULL 1 & NULL 1+NULL 1-NULL
  150. NULL NULL NULL NULL
  151. --------------
  152. select NULL=NULL,NULL<>NULL,NULL IS NULL, NULL IS NOT NULL,IFNULL(NULL,1.1)+0,IFNULL(NULL,1) | 0
  153. --------------
  154. NULL=NULL NULL<>NULL NULL IS NULL NULL IS NOT NULL IFNULL(NULL,1.1)+0 IFNULL(NULL,1) | 0
  155. NULL NULL 1 0 1.1 1
  156. --------------
  157. select strcmp("a",NULL),(1<NULL)+0.0,NULL regexp "a",null like "a%","a%" like null
  158. --------------
  159. strcmp("a",NULL) (1<NULL)+0.0 NULL regexp "a" null like "a%" "a%" like null
  160. NULL NULL NULL NULL NULL
  161. --------------
  162. select concat("a",NULL),replace(NULL,"a","b"),replace("string","i",NULL),replace("string",NULL,"i"),insert("abc",1,1,NULL),left(NULL,1)
  163. --------------
  164. concat("a",NULL) replace(NULL,"a","b") replace("string","i",NULL) replace("string",NULL,"i") insert("abc",1,1,NULL) left(NULL,1)
  165. NULL NULL NULL NULL NULL NULL
  166. --------------
  167. select field(NULL,"a","b","c")
  168. --------------
  169. field(NULL,"a","b","c")
  170. 0
  171. --------------
  172. select 2 between null and 1,2 between 3 AND NULL,NULL between 1 and 2,2 between NULL and 3, 2 between 1 AND null,2 between null and 1,2 between 3 AND NULL
  173. --------------
  174. 2 between null and 1 2 between 3 AND NULL NULL between 1 and 2 2 between NULL and 3 2 between 1 AND null 2 between null and 1 2 between 3 AND NULL
  175. 0 0 NULL NULL NULL 0 0
  176. --------------
  177. select insert("aa",100,1,"b"),insert("aa",1,3,"b"),left("aa",-1),substring("a",1,2)
  178. --------------
  179. insert("aa",100,1,"b") insert("aa",1,3,"b") left("aa",-1) substring("a",1,2)
  180. aa b a
  181. --------------
  182. select elt(2,1),field(NULL,"a","b","c")
  183. --------------
  184. elt(2,1) field(NULL,"a","b","c")
  185. NULL 0
  186. --------------
  187. select locate("a","b",2),locate("","a",1),ltrim("a"),rtrim("a")
  188. --------------
  189. locate("a","b",2) locate("","a",1) ltrim("a") rtrim("a")
  190. 0 1 a a
  191. --------------
  192. select concat("1","2")|0,concat("1",".5")+0.0
  193. --------------
  194. concat("1","2")|0 concat("1",".5")+0.0
  195. 12 1.5
  196. --------------
  197. select from_days(to_days("960101")),to_days(960201)-to_days("19960101"),to_days(curdate()+1)-to_days(curdate()),weekday("1997-01-01")
  198. --------------
  199. from_days(to_days("960101")) to_days(960201)-to_days("19960101") to_days(curdate()+1)-to_days(curdate()) weekday("1997-01-01")
  200. 1996-01-01 31 1 2
  201. --------------
  202. select period_add("9602",-12),period_diff(199505,"9404")
  203. --------------
  204. period_add("9602",-12) period_diff(199505,"9404")
  205. 199502 13
  206. --------------
  207. select now()-now(),weekday(curdate())-weekday(now()),unix_timestamp()-unix_timestamp(now())
  208. --------------
  209. now()-now() weekday(curdate())-weekday(now()) unix_timestamp()-unix_timestamp(now())
  210. 0 0 0
  211. --------------
  212. select now(),now()+0,curdate(),weekday(curdate()),weekday(now()),unix_timestamp(),unix_timestamp(now())
  213. --------------
  214. now() now()+0 curdate() weekday(curdate()) weekday(now()) unix_timestamp() unix_timestamp(now())
  215. 1998-08-17 04:24:33 19980817042433 1998-08-17 0 0 903317073 903317073