随笔分类 - mysql
摘要：mysql> select * from test -> ; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | ...
阅读全文
摘要：mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia...
阅读全文
摘要：mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia...
阅读全文
摘要：mysql> select * from user; +------+----------+-----------+ | id | name | address | +------+----------+-----------+ | 1 | xiaoming | beijing | | 2 | xiaobai | shandong | | 3 | x...
阅读全文
摘要：mysql> select * from user; +------+----------+-----------+ | id | name | address | +------+----------+-----------+ | 1 | xiaoming | beijing | | 2 | xiaobai | shandong | | 3 | x...
阅读全文
摘要：mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia...
阅读全文
摘要：mysql> select rtrim(" cdcdcd "); +--------------------+ | rtrim(" cdcdcd ") | +--------------------+ | cdcdcd | +--------------------+ 1 row in set (0.00 sec)
阅读全文
摘要：mysql> select upper(" cdcdcd"); +------------------+ | upper(" cdcdcd") | +------------------+ | CDCDCD | +------------------+ 1 row in set (0.00 sec)
阅读全文
摘要：mysql> select right(" dedede",6); +---------------------+ | right(" dedede",6) | +---------------------+ | dedede | +---------------------+ 1 row in set (0.00 sec) mysql> select rig...
阅读全文
摘要：mysql> select " DFREF"; +--------+ | DFREF | +--------+ | DFREF | +--------+ 1 row in set (0.00 sec) mysql> select lower(" DFREF"); +-----------------+ | lower(" DFREF") | +-----------------+ | ...
阅读全文
摘要：mysql> select " dedede"; +----------+ | dedede | +----------+ | dedede | +----------+ 1 row in set (0.00 sec) mysql> select ltrim(" dedede"); +-------------------+ | ltrim(" dedede") | +-...
阅读全文
摘要：mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia...
阅读全文
摘要：mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia...
阅读全文
摘要：mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia...
阅读全文
摘要：mysql> select * from test; +----+------------+-------+-----------+ | id | name | score | subject | +----+------------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xia...
阅读全文
摘要：字符类 [: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...
阅读全文
摘要：mysql> select concat(name,"**",id) as test from test; +----------------+ | test | +----------------+ | xiaoming**1 | | xiaohong**2 | | xiaohong**3 | | xiaohong**4 | | xiaohong...
阅读全文
摘要：mysql> select " ddd dddee "; +--------------+ | ddd dddee | +--------------+ | ddd dddee | +--------------+ 1 row in set (0.00 sec) mysql> select rtrim(" ddd dddee "); +------------------...
阅读全文
摘要：mysql> select * from test; +----+----------+-------+-----------+ | id | name | score | subject | +----+----------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xiaohong | ...
阅读全文
摘要：mysql> select * from test; +----+----------+-------+-----------+ | id | name | score | subject | +----+----------+-------+-----------+ | 1 | xiaoming | 89 | shuxue | | 2 | xiaohong | ...
阅读全文