摘要:
MD5:密码为web页面做准备,建议使用MD5 PASSWORD() :修改当前用户或其他用户密码 mysql> SELECT MD5('admin'); #对admin进行MD5的加密(32位)+ +| MD5('admin') |+ +| 21232f297a57a5a743894a0e4a80 阅读全文
摘要:
聚合函数特点:只有一个返回值 一般用在数据表中的某些信息。 1、mysql> SELECT * FROM test;+ + +| id | username |+ + +| 1 | John || 2 | Mary || 3 | 1%Lily || 4 | Rose || 5 | NULL || 6 阅读全文
摘要:
mysql> SELECT CONNECTION_ID(); #当前连接的ID+ +| CONNECTION_ID() |+ +| 1 |+ +1 row in set (0.00 sec) mysql> SELECT DATABASE(); #当前打开的数据库+ +| DATABASE() |+ 阅读全文
摘要:
mysql> SELECT NOW(); #返回(打印)当前日期和时间+ +| NOW() |+ +| 2017-03-28 17:53:34 |+ +1 row in set (0.01 sec) mysql> SELECT CURDATE(); #返回(打印)当前日期+ +| CURDATE() 阅读全文
摘要:
mysql> SELECT 15 BETWEEN 1 AND 22;+ +| 15 BETWEEN 1 AND 22 |+ +| 1 |+ +1 row in set (0.00 sec) mysql>mysql> SELECT 22 BETWEEN 1 AND 22;+ +| 22 BETWEEN 阅读全文
摘要:
mysql> SELECT CEIL(3.01); # 进1取整+ +| CEIL(3.01) |+ +| 4 |+ +1 row in set (0.00 sec) mysql> SELECT FLOOR(3.99); # 舍1取整+ +| FLOOR(3.99) |+ +| 3 |+ +1 ro 阅读全文
摘要:
1、CONCAT() 字符连接 (1)mysql> SELECT CONCAT('imooc', 'MYSQL');+ +| CONCAT('imooc', 'MYSQL') |+ +| imoocMYSQL |+ + (2)mysql> SELECT CONCAT('imooc','-','MYS 阅读全文