【MySQL】REPEAT()函数
复制字符串,有点儿像Python中*的作用,做个测试,有点儿意思。
语法:REPEAT(str,count)
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 |
## 复制字符串Abc,共5套'Abc'字符串 mysql> select REPEAT('Abc',5); +-----------------+ | REPEAT('Abc',5) | +-----------------+ | AbcAbcAbcAbcAbc | +-----------------+ 1 row in set (0.00 sec) mysql> mysql> select REPEAT('Abc',1); +-----------------+ | REPEAT('Abc',1) | +-----------------+ | Abc | +-----------------+ 1 row in set (0.00 sec) mysql> ## 如果参数为<=0,那么返回空 mysql> select REPEAT('Abc',0); +-----------------+ | REPEAT('Abc',0) | +-----------------+ | | +-----------------+ 1 row in set (0.00 sec) mysql> select REPEAT('Abc',-1); +------------------+ | REPEAT('Abc',-1) | +------------------+ | | +------------------+ 1 row in set (0.00 sec) mysql> ## 这个比较有意思,还可以是小数,不过遵循四舍五入 mysql> select REPEAT('Abc',1.5); +-------------------+ | REPEAT('Abc',1.5) | +-------------------+ | AbcAbc | +-------------------+ 1 row in set (0.00 sec) mysql> select REPEAT('Abc',1.3); +-------------------+ | REPEAT('Abc',1.3) | +-------------------+ | Abc | +-------------------+ 1 row in set (0.00 sec) mysql> |