MySQL函数大全及用法示例
1、字符串函数
ascii(str)
返回字符串str的第一个字符的ascii值(str是空串时返回0)
mysql> select ascii('2');...如果字符串str句首是单字节返回与ascii()函数返回的相同值。...b','a,b,c,d');
-> 2
make_set(bits,str1,str2,...)...("b","a","c");
-> "a"
greatest(x,y,...)...);
-> 767.0
mysql> select greatest("b","a","c");
-> "c"
3、时期时间函数
dayofweek(date