MySQL支持SQL常用的函数,如集合函数、字符串处理函数和日期函数等。一些编程过程中经常遇到的MySQL函数:
COUNT() 用来统计表中记录个数或者列中值的个数
MAX() 返回某列中的最大值
MIN() 返回某列中的最小值
SUM() 将指定列的值求和
AVG() 计算指定列的平均值
lENGTH() 计算字符串的长度
SUBSTRING() 截取子字符串
YEAR() 返回指定日期的年份,范围在1000~9999之间。类似的还有MONTH() HOUR()
UNIX_TIMESTAMP() 返回一个UNIX时间戳
DATE_FORMAT() 将一个日期格式化
NOW() 返回MySQL服务器系统的当前日期和时间
=========================================================================================
SELSECT COUNT(*) FROM users;
SELECT COUNT(name) FROM users WHERE name LIKE 'J%';
SELECT MAX(salary) AS max_salary FROM emp_salary;
SELECT MIN(salary) AS min_salary FROM emp_salary;
SELECT SUM(salary) AS total_salary FROM emp_salary;
SELECT AVG(salary) AS avg_salary FROM emp_salary;
SELECT LENGTH('string in MySQL');
SUBSTRING(string,pos,len);
SELECT YEAR(created_time) AS year FROM users WHERE id=3;
SELECT UNIX_TIMESTAMP() AS timestamp;
SELECT DATE_FORMAT(created_time,'%Y年%m月%d日') AS DATE FROM users WHERE id=3;
SELECT NOW() AS date_time;
版权声明:本文为博主原创文章,未经博主允许不得转载。