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;
版权声明:本文为博主原创文章,未经博主允许不得转载。