API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 25th, 2013
152
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 12.60 KB | None | 0 0
raw download clone embed print report
  1. mysql> select id from test where random_value >= RAND() LIMIT 5;
  2. +----+
  3. | id |
  4. +----+
  5. |  4 |
  6. |  5 |
  7. |  7 |
  8. | 11 |
  9. | 13 |
  10. +----+
  11. 5 rows in set (0.00 sec)
  12.  
  13. mysql> select id from test where random_value >= RAND() LIMIT 5;
  14. +----+
  15. | id |
  16. +----+
  17. |  4 |
  18. |  5 |
  19. | 13 |
  20. | 16 |
  21. | 21 |
  22. +----+
  23. 5 rows in set (0.00 sec)
  24.  
  25. mysql> select id from test where random_value >= RAND() LIMIT 5;
  26. +----+
  27. | id |
  28. +----+
  29. |  5 |
  30. | 11 |
  31. | 13 |
  32. | 16 |
  33. | 21 |
  34. +----+
  35. 5 rows in set (0.00 sec)
  36.  
  37. mysql> select id from test where random_value >= RAND() LIMIT 5;
  38. +----+
  39. | id |
  40. +----+
  41. | 11 |
  42. | 13 |
  43. | 15 |
  44. | 17 |
  45. | 21 |
  46. +----+
  47. 5 rows in set (0.00 sec)
  48.  
  49. mysql> select id from test where random_value >= RAND() LIMIT 5;
  50. +----+
  51. | id |
  52. +----+
  53. |  5 |
  54. |  7 |
  55. | 11 |
  56. | 13 |
  57. | 15 |
  58. +----+
  59. 5 rows in set (0.00 sec)
  60.  
  61. mysql> select id from test where random_value >= RAND() LIMIT 5;
  62. +----+
  63. | id |
  64. +----+
  65. |  5 |
  66. | 11 |
  67. | 15 |
  68. | 16 |
  69. | 21 |
  70. +----+
  71. 5 rows in set (0.00 sec)
  72.  
  73. mysql> select id from test where random_value >= RAND() LIMIT 5;
  74. +----+
  75. | id |
  76. +----+
  77. |  3 |
  78. |  5 |
  79. |  7 |
  80. | 11 |
  81. | 13 |
  82. +----+
  83. 5 rows in set (0.00 sec)
  84.  
  85. mysql> select id from test where random_value >= RAND() LIMIT 5;
  86. +----+
  87. | id |
  88. +----+
  89. |  4 |
  90. |  5 |
  91. |  7 |
  92. | 13 |
  93. | 15 |
  94. +----+
  95. 5 rows in set (0.00 sec)
  96.  
  97. mysql> select id from test where random_value >= RAND() LIMIT 5;
  98. +----+
  99. | id |
  100. +----+
  101. |  4 |
  102. |  5 |
  103. |  7 |
  104. | 11 |
  105. | 13 |
  106. +----+
  107. 5 rows in set (0.00 sec)
  108.  
  109. mysql> select id from test where random_value >= RAND() LIMIT 5;
  110. +----+
  111. | id |
  112. +----+
  113. |  6 |
  114. |  7 |
  115. | 11 |
  116. | 13 |
  117. | 17 |
  118. +----+
  119. 5 rows in set (0.00 sec)
  120.  
  121. mysql> select id from test where random_value >= RAND() LIMIT 5;
  122. +----+
  123. | id |
  124. +----+
  125. |  3 |
  126. |  5 |
  127. |  7 |
  128. | 11 |
  129. | 13 |
  130. +----+
  131. 5 rows in set (0.00 sec)
  132.  
  133. +-----+--------------+
  134. | id  | random_value |
  135. +-----+--------------+
  136. |   3 |     0.347546 |
  137. |   4 |     0.374211 |
  138. |   5 |     0.828413 |
  139. |   6 |     0.019436 |
  140. |   7 |      0.61194 |
  141. |   8 |   0.00138987 |
  142. |   9 |     0.171131 |
  143. |  11 |     0.851484 |
  144. |  13 |     0.744026 |
  145. |  14 |     0.165681 |
  146. |  15 |     0.596325 |
  147. |  16 |     0.484581 |
  148. |  17 |     0.633932 |
  149. |  21 |     0.715915 |
  150. |  22 |     0.677781 |
  151. |  23 |      0.24116 |
  152. |  24 |     0.172458 |
  153. |  25 |     0.138811 |
  154. |  27 |     0.176678 |
  155. |  28 |     0.466957 |
  156. |  29 |     0.804753 |
  157. |  30 |     0.622895 |
  158. |  31 |     0.700214 |
  159. |  32 |     0.632385 |
  160. |  33 |    0.0612852 |
  161. |  34 |      0.40927 |
  162. |  35 |     0.862493 |
  163. |  36 |    0.0846571 |
  164. |  37 |     0.835806 |
  165. |  38 |     0.925058 |
  166. |  39 |     0.117872 |
  167. |  41 |     0.814185 |
  168. |  42 |     0.717309 |
  169. |  43 |     0.143989 |
  170. |  45 |     0.568021 |
  171. |  46 |     0.408137 |
  172. |  49 |     0.336622 |
  173. |  50 |     0.458698 |
  174. |  51 |     0.283624 |
  175. |  52 |    0.0420257 |
  176. |  53 |     0.359257 |
  177. |  54 |     0.670209 |
  178. |  55 |     0.273272 |
  179. |  56 |     0.355733 |
  180. |  57 |     0.958849 |
  181. |  58 |     0.727046 |
  182. |  59 |     0.758682 |
  183. |  60 |     0.612272 |
  184. |  61 |     0.785313 |
  185. |  62 |      0.08975 |
  186. |  63 |    0.0928114 |
  187. |  64 |     0.194807 |
  188. |  65 |       0.6956 |
  189. |  66 |      0.89358 |
  190. |  67 |     0.381102 |
  191. |  68 |     0.224768 |
  192. |  69 |     0.980535 |
  193. |  70 |      0.22837 |
  194. |  71 |     0.200246 |
  195. |  72 |      0.31612 |
  196. |  74 |     0.979863 |
  197. |  75 |     0.950955 |
  198. |  76 |     0.815186 |
  199. |  77 |     0.223066 |
  200. |  78 |     0.669772 |
  201. |  79 |     0.679661 |
  202. |  80 |      0.38899 |
  203. |  81 |     0.905968 |
  204. |  82 |      0.36287 |
  205. |  83 |    0.0964452 |
  206. |  84 |     0.393616 |
  207. |  85 |     0.678745 |
  208. |  86 |     0.212877 |
  209. |  87 |    0.0281478 |
  210. |  88 |     0.502109 |
  211. |  89 |     0.426103 |
  212. |  90 |     0.624187 |
  213. |  91 |     0.842627 |
  214. |  92 |     0.340571 |
  215. |  93 |     0.174977 |
  216. |  94 |     0.853172 |
  217. |  96 |     0.740928 |
  218. |  97 |     0.145125 |
  219. |  98 |     0.502842 |
  220. |  99 |     0.078834 |
  221. | 100 |     0.885644 |
  222. | 101 |     0.191718 |
  223. | 102 |     0.301658 |
  224. | 103 |     0.933135 |
  225. | 104 |     0.760702 |
  226. | 105 |    0.0041037 |
  227. | 106 |     0.738413 |
  228. | 107 |     0.679756 |
  229. | 108 |     0.183538 |
  230. | 109 |     0.878424 |
  231. | 110 |     0.841506 |
  232. | 111 |     0.572257 |
  233. | 112 |     0.336767 |
  234. | 113 |     0.967063 |
  235. | 114 |     0.825015 |
  236. | 115 |     0.223885 |
  237. | 116 |     0.644383 |
  238. | 117 |     0.550257 |
  239. | 118 |     0.818136 |
  240. | 119 |     0.439909 |
  241. | 121 |     0.745137 |
  242. | 122 |     0.405958 |
  243. | 123 |     0.794378 |
  244. | 124 |     0.754015 |
  245. | 125 |     0.386943 |
  246. | 127 |     0.672668 |
  247. | 128 |     0.202514 |
  248. | 131 |     0.994563 |
  249. | 132 |     0.365274 |
  250. | 133 |     0.842681 |
  251. | 134 |     0.117585 |
  252. | 135 |      0.05988 |
  253. | 136 |     0.946645 |
  254. | 137 |     0.553588 |
  255. | 138 |     0.928002 |
  256. | 139 |     0.979245 |
  257. | 140 |     0.112221 |
  258. | 143 |     0.623371 |
  259. | 144 |      0.78019 |
  260. | 145 |    0.0308385 |
  261. | 146 |     0.813622 |
  262. | 147 |     0.975594 |
  263. | 148 |     0.437105 |
  264. | 149 |     0.258744 |
  265. | 150 |     0.982405 |
  266. | 151 |     0.135791 |
  267. | 152 |      0.73174 |
  268. | 153 |     0.251327 |
  269. | 154 |    0.0614174 |
  270. | 155 |     0.553105 |
  271. | 156 |     0.581272 |
  272. | 157 |     0.247047 |
  273. | 158 |     0.491417 |
  274. | 159 |     0.715947 |
  275. | 160 |     0.105481 |
  276. | 161 |     0.379565 |
  277. | 162 |     0.581384 |
  278. | 163 |     0.768223 |
  279. | 164 |    0.0969648 |
  280. | 165 |     0.180154 |
  281. | 166 |     0.609876 |
  282. | 167 |     0.508919 |
  283. | 168 |     0.714967 |
  284. | 169 |    0.0480777 |
  285. | 170 |    0.0954876 |
  286. | 171 |     0.333205 |
  287. | 172 |      0.37956 |
  288. | 173 |     0.898188 |
  289. | 174 |      0.35226 |
  290. | 175 |    0.0667333 |
  291. | 176 |     0.276888 |
  292. | 177 |      0.18424 |
  293. | 178 |    0.0905367 |
  294. | 179 |     0.899963 |
  295. | 180 |     0.228205 |
  296. | 181 |     0.441138 |
  297. | 182 |     0.521073 |
  298. | 183 |      0.28195 |
  299. | 184 |     0.846531 |
  300. | 185 |     0.386806 |
  301. | 186 |     0.394438 |
  302. | 188 |     0.811769 |
  303. | 189 |     0.875534 |
  304. | 190 |     0.942362 |
  305. | 191 |     0.085207 |
  306. | 192 |      0.59895 |
  307. | 193 |     0.739128 |
  308. | 194 |     0.898793 |
  309. | 195 |     0.276578 |
  310. | 196 |     0.686511 |
  311. | 197 |     0.602823 |
  312. | 198 |     0.954582 |
  313. | 199 |     0.964441 |
  314. | 200 |     0.958458 |
  315. | 201 |     0.898967 |
  316. | 202 |     0.619463 |
  317. | 203 |     0.400412 |
  318. | 204 |     0.143673 |
  319. | 205 |     0.517129 |
  320. | 206 |     0.154625 |
  321. | 207 |      0.22174 |
  322. | 208 |     0.644824 |
  323. | 209 |     0.558902 |
  324. | 210 |     0.860036 |
  325. | 211 |     0.623476 |
  326. | 212 |     0.537272 |
  327. | 213 |      0.81593 |
  328. | 214 |     0.467833 |
  329. | 215 |     0.891378 |
  330. | 216 |    0.0533887 |
  331. | 217 |      0.59281 |
  332. | 218 |     0.803885 |
  333. | 219 |     0.240996 |
  334. | 220 |     0.793323 |
  335. | 221 |     0.243627 |
  336. | 222 |     0.838168 |
  337. | 223 |     0.459958 |
  338. | 224 |     0.785284 |
  339. | 225 |     0.546549 |
  340. | 226 |      0.37689 |
  341. | 227 |     0.244804 |
  342. | 228 |    0.0933521 |
  343. | 229 |     0.732347 |
  344. | 230 |     0.381679 |
  345. | 231 |     0.711356 |
  346. | 232 |     0.411741 |
  347. | 233 |     0.924638 |
  348. | 234 |     0.387966 |
  349. | 235 |     0.165916 |
  350. | 236 |     0.665684 |
  351. | 237 |     0.830669 |
  352. | 239 |     0.156295 |
  353. | 240 |     0.289467 |
  354. | 241 |     0.978452 |
  355. | 243 |    0.0238587 |
  356. | 244 |     0.183937 |
  357. | 245 |     0.848109 |
  358. | 246 |     0.688735 |
  359. | 247 |     0.899347 |
  360. | 248 |     0.430531 |
  361. | 249 |     0.454612 |
  362. | 250 |     0.981469 |
  363. | 251 |     0.543508 |
  364. | 252 |     0.773135 |
  365. | 253 |      0.23515 |
  366. | 254 |     0.856345 |
  367. | 255 |     0.576276 |
  368. | 256 |     0.312346 |
  369. | 257 |       0.8329 |
  370. | 258 |     0.227463 |
  371. | 259 |     0.638616 |
  372. | 260 |     0.510688 |
  373. | 262 |     0.637594 |
  374. | 263 |     0.655907 |
  375. | 264 |     0.366751 |
  376. | 265 |     0.866036 |
  377. | 266 |     0.229925 |
  378. | 267 |     0.551517 |
  379. | 268 |    0.0678092 |
  380. | 269 |     0.684496 |
  381. | 270 |     0.219053 |
  382. | 271 |    0.0417776 |
  383. | 272 |     0.551728 |
  384. | 273 |     0.633309 |
  385. | 274 |     0.511362 |
  386. | 275 |     0.656881 |
  387. | 276 |     0.750318 |
  388. | 277 |     0.780946 |
  389. | 278 |     0.653779 |
  390. | 279 |     0.926055 |
  391. | 280 |     0.668938 |
  392. | 281 |     0.566527 |
  393. | 282 |     0.825822 |
  394. | 283 |     0.429527 |
  395. | 284 |     0.670171 |
  396. | 285 |    0.0622744 |
  397. | 286 |     0.300858 |
  398. | 287 |     0.317468 |
  399. | 288 |     0.684765 |
  400. | 289 |      0.47142 |
  401. | 290 |     0.302805 |
  402. | 291 |    0.0997647 |
  403. | 292 |     0.590409 |
  404. | 293 |     0.652752 |
  405. | 294 |     0.492534 |
  406. | 295 |     0.504413 |
  407. | 296 |    0.0444645 |
  408. | 297 |     0.709082 |
  409. | 298 |     0.412018 |
  410. | 299 |     0.932845 |
  411. | 300 |     0.428169 |
  412. | 301 |     0.342311 |
  413. | 302 |     0.427048 |
  414. | 303 |     0.108306 |
  415. | 304 |     0.260385 |
  416. | 305 |     0.977007 |
  417. | 306 |     0.103882 |
  418. | 307 |      0.58839 |
  419. | 308 |     0.630304 |
  420. | 309 |     0.386347 |
  421. | 310 |    0.0408261 |
  422. | 311 |    0.0450886 |
  423. | 312 |     0.102965 |
  424. | 313 |     0.379557 |
  425. | 314 |     0.588891 |
  426. | 315 |     0.805783 |
  427. | 317 |     0.262243 |
  428. | 318 |     0.893865 |
  429. | 319 |     0.682598 |
  430. | 320 |     0.731393 |
  431. | 321 |     0.609172 |
  432. | 322 |     0.851682 |
  433. | 323 |     0.430894 |
  434. | 324 |     0.599422 |
  435. | 325 |     0.704428 |
  436. | 326 |     0.723874 |
  437. | 328 |     0.506088 |
  438. | 329 |     0.358817 |
  439. | 330 |     0.275823 |
  440. | 331 |     0.302663 |
  441. | 332 |     0.685845 |
  442. | 334 |     0.521236 |
  443. | 335 |     0.548646 |
  444. | 336 |     0.179522 |
  445. | 337 |      0.25167 |
  446. | 338 |     0.719785 |
  447. | 339 |     0.843916 |
  448. | 340 |     0.060225 |
  449. | 341 |     0.769377 |
  450. | 342 |     0.666208 |
  451. | 343 |    0.0229091 |
  452. | 344 |     0.115922 |
  453. | 345 |     0.510884 |
  454. | 346 |     0.206655 |
  455. | 347 |      0.50062 |
  456. | 348 |     0.883138 |
  457. | 349 |     0.913827 |
  458. | 350 |     0.919722 |
  459. | 351 |     0.857128 |
  460. | 352 |     0.526473 |
  461. | 354 |    0.0609829 |
  462. | 355 |     0.725495 |
  463. | 356 |     0.444526 |
  464. | 358 |    0.0461463 |
  465. | 359 |     0.897153 |
  466. | 360 |     0.347326 |
  467. | 361 |    0.0451699 |
  468. | 363 |     0.183872 |
  469. | 364 |     0.783852 |
  470. | 365 |     0.367644 |
  471. | 366 |     0.486661 |
  472. | 367 |     0.330376 |
  473. | 368 |     0.191895 |
  474. | 369 |      0.96835 |
  475. | 370 |     0.266063 |
  476. | 371 |     0.425266 |
  477. | 372 |      0.32814 |
  478. | 373 |     0.364902 |
  479. | 374 |     0.840089 |
  480. | 375 |     0.105741 |
  481. | 376 |   0.00843815 |
  482. | 377 |     0.724967 |
  483. | 378 |     0.599522 |
  484. | 379 |     0.822706 |
  485. | 380 |     0.314967 |
  486. | 381 |     0.106716 |
  487. | 382 |     0.588678 |
  488. | 383 |     0.623244 |
  489. | 384 |     0.350187 |
  490. | 385 |     0.881202 |
  491. | 386 |     0.355448 |
  492. | 387 |     0.133635 |
  493. | 388 |     0.601831 |
  494. | 389 |     0.608251 |
  495. | 390 |     0.235761 |
  496. | 391 |     0.354053 |
  497. | 392 |    0.0629806 |
  498. | 393 |     0.252745 |
  499. | 394 |    0.0747821 |
  500. | 396 |     0.615676 |
  501. | 397 |     0.854035 |
  502. | 398 |     0.423145 |
  503. | 399 |     0.553621 |
  504. | 400 |     0.498668 |
  505. | 401 |     0.832479 |
  506. | 402 |     0.666392 |
  507. | 403 |     0.834521 |
  508. | 404 |     0.173429 |
  509. | 405 |     0.363585 |
  510. | 406 |     0.297634 |
  511. | 407 |     0.397418 |
  512. | 408 |    0.0941869 |
  513. | 409 |     0.278681 |
  514. | 410 |     0.110842 |
  515. | 411 |     0.718168 |
  516. | 412 |     0.258315 |
  517. | 413 |      0.13707 |
  518. | 414 |     0.910405 |
  519. | 415 |     0.140816 |
  520. | 416 |     0.972863 |
  521. | 417 |     0.441869 |
  522. | 418 |     0.290754 |
  523. | 419 |     0.128163 |
  524. | 420 |     0.768553 |
  525. | 421 |     0.458276 |
  526. | 422 |      0.98572 |
  527. | 423 |     0.553774 |
  528. | 424 |     0.811711 |
  529. | 425 |     0.397231 |
  530. | 426 |     0.551022 |
  531. | 427 |     0.563417 |
  532. | 428 |     0.164019 |
  533. | 429 |     0.129844 |
  534. | 430 |     0.157163 |
  535. | 431 |     0.396282 |
  536. | 432 |     0.509923 |
  537. | 433 |     0.360767 |
  538. | 434 |     0.274065 |
  539. | 435 |     0.288025 |
  540. | 436 |     0.617929 |
  541. | 437 |      0.22557 |
  542. | 438 |     0.274064 |
  543. | 439 |     0.693611 |
  544. | 440 |     0.645863 |
  545. | 441 |     0.148483 |
  546. | 442 |     0.804824 |
  547. | 443 |      0.57867 |
  548. | 444 |      0.47888 |
  549. | 445 |     0.658387 |
  550. | 446 |     0.855299 |
  551. | 447 |     0.301331 |
  552. | 449 |      0.94076 |
  553. | 450 |     0.799807 |
  554. | 451 |     0.176753 |
  555. | 452 |     0.484346 |
  556. | 453 |      0.89147 |
  557. | 454 |   0.00431281 |
  558. | 455 |     0.347154 |
  559. | 456 |      0.72283 |
  560. | 457 |     0.572691 |
  561. | 458 |     0.694963 |
  562. | 459 |     0.756741 |
  563. | 460 |     0.698815 |
  564. | 461 |     0.223854 |
  565. | 462 |    0.0228247 |
  566. | 463 |     0.442561 |
  567. | 464 |     0.144333 |
  568. | 465 |     0.393981 |
  569. | 466 |     0.536908 |
  570. | 467 |     0.502594 |
  571. | 468 |     0.902245 |
  572. | 469 |   0.00344565 |
  573. | 470 |     0.310492 |
  574. | 471 |     0.542126 |
  575. | 472 |      0.77915 |
  576. | 473 |     0.269374 |
  577. | 474 |   0.00942122 |
  578. | 476 |     0.238983 |
  579. | 477 |     0.166652 |
  580. | 478 |      0.11631 |
  581. | 479 |    0.0815959 |
  582. | 480 |    0.0590487 |
  583. | 481 |    0.0504557 |
  584. | 482 |    0.0751326 |
  585. | 483 |     0.224296 |
  586. | 484 |     0.896082 |
  587. | 485 |     0.807522 |
  588. | 486 |     0.349363 |
  589. | 487 |     0.324249 |
  590. | 488 |     0.573158 |
  591. | 489 |     0.893043 |
  592. +-----+--------------+
  593. 456 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!