摘要：
mysql> select * from user; +------+----------+-----------+ | id | name | address | +------+----------+-----------+ | 1 | xiaoming | beijing | | 2 | xiaobai | shandong | | 3 | x... 阅读全文
posted @ 2019-08-06 23:38
anobscureretreat
阅读(188)
评论(0)
推荐(0)
摘要：
mysql> select * from user; +------+----------+-----------+ | id | name | address | +------+----------+-----------+ | 1 | xiaoming | beijing | | 2 | xiaobai | shandong | | 3 | x... 阅读全文
posted @ 2019-08-06 15:46
anobscureretreat
阅读(198)
评论(0)
推荐(0)
摘要：
mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia... 阅读全文
posted @ 2019-08-06 14:44
anobscureretreat
阅读(195)
评论(0)
推荐(0)
摘要：
mysql> select rtrim(" cdcdcd "); +--------------------+ | rtrim(" cdcdcd ") | +--------------------+ | cdcdcd | +--------------------+ 1 row in set (0.00 sec) 阅读全文
posted @ 2019-08-06 12:52
anobscureretreat
阅读(1128)
评论(0)
推荐(0)
摘要：
mysql> select upper(" cdcdcd"); +------------------+ | upper(" cdcdcd") | +------------------+ | CDCDCD | +------------------+ 1 row in set (0.00 sec) 阅读全文
posted @ 2019-08-06 12:48
anobscureretreat
阅读(1717)
评论(0)
推荐(0)
摘要：
mysql> select right(" dedede",6); +---------------------+ | right(" dedede",6) | +---------------------+ | dedede | +---------------------+ 1 row in set (0.00 sec) mysql> select rig... 阅读全文
posted @ 2019-08-06 12:47
anobscureretreat
阅读(1946)
评论(0)
推荐(0)
摘要：
mysql> select " DFREF"; +--------+ | DFREF | +--------+ | DFREF | +--------+ 1 row in set (0.00 sec) mysql> select lower(" DFREF"); +-----------------+ | lower(" DFREF") | +-----------------+ | ... 阅读全文
posted @ 2019-08-06 12:17
anobscureretreat
阅读(3780)
评论(0)
推荐(0)
摘要：
mysql> select " dedede"; +----------+ | dedede | +----------+ | dedede | +----------+ 1 row in set (0.00 sec) mysql> select ltrim(" dedede"); +-------------------+ | ltrim(" dedede") | +-... 阅读全文
posted @ 2019-08-06 12:00
anobscureretreat
阅读(1590)
评论(0)
推荐(0)
摘要：
mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia... 阅读全文
posted @ 2019-08-06 11:42
anobscureretreat
阅读(3853)
评论(0)
推荐(0)
摘要：
mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia... 阅读全文
posted @ 2019-08-06 11:26
anobscureretreat
阅读(2044)
评论(0)
推荐(0)
摘要：
mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia... 阅读全文
posted @ 2019-08-06 11:12
anobscureretreat
阅读(601)
评论(0)
推荐(0)
摘要：
mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia... 阅读全文
posted @ 2019-08-06 10:59
anobscureretreat
阅读(1667)
评论(0)
推荐(0)
摘要：
字符类 [:alnum:]=[a-zA-Z0-9] [:alpha:]=[a-zA-Z] [:digit:]=[0-9] [:lower:]=[a-z] [:upper:]=[A-Z] [:xdigit:]=[a-fA-F0-9] 重复元字符 * = >=0 + = >=1 = {1,} ? = {0,1} {n} 指定数目 {n,} = >=n {n,m} = >=n... 阅读全文
posted @ 2019-08-06 01:55
anobscureretreat
阅读(652)
评论(0)
推荐(0)
摘要：
mysql> select concat(name,"**",id) as test from test; +----------------+ | test | +----------------+ | xiaoming**1 | | xiaohong**2 | | xiaohong**3 | | xiaohong**4 | | xiaohong... 阅读全文
posted @ 2019-08-06 01:40
anobscureretreat
阅读(1038)
评论(0)
推荐(0)
摘要：
mysql> select " ddd dddee "; +--------------+ | ddd dddee | +--------------+ | ddd dddee | +--------------+ 1 row in set (0.00 sec) mysql> select rtrim(" ddd dddee "); +------------------... 阅读全文
posted @ 2019-08-06 01:33
anobscureretreat
阅读(5844)
评论(0)
推荐(0)
摘要：
mysql> select * from test; +----+----------+-------+-----------+ | id | name | score | subject | +----+----------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xiaohong | ... 阅读全文
posted @ 2019-08-06 00:54
anobscureretreat
阅读(457)
评论(0)
推荐(0)
摘要：
mysql> select * from test; +----+----------+-------+-----------+ | id | name | score | subject | +----+----------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xiaohong | ... 阅读全文
posted @ 2019-08-06 00:44
anobscureretreat
阅读(586)
评论(0)
推荐(0)
摘要：
mysql> select * from test; +----+----------+-------+-----------+ | id | name | score | subject | +----+----------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xiaohong | ... 阅读全文
posted @ 2019-08-06 00:14
anobscureretreat
阅读(172)
评论(0)
推荐(0)
浙公网安备 33010602011771号