51Dev开发社区
登录 注册

#mysql

mysql tan() 函数
 mysql>selecttan(pi()/4);+--------------------+|tan(pi()/4)|+--------------------+|0.9999999999999999|+--------------------+1rowinset(0.00sec) ...
代码星球 ·2020-11-01

mysql pi() 获取pi
 mysql>selectpi();+----------+|pi()|+----------+|3.141593|+----------+1rowinset(0.00sec) ...
代码星球 ·2020-11-01

mysql mod() 获取余数
 mysql>selectmod(16,3);+-----------+|mod(16,3)|+-----------+|1|+-----------+1rowinset(0.00sec) ...
代码星球 ·2020-11-01

mysql sqrt() 函数
 mysql>selectsqrt(16);+----------+|sqrt(16)|+----------+|4|+----------+1rowinset(0.00sec) ...
代码星球 ·2020-11-01

mysql sin() 函数
 mysql>selectsin(PI()/6);+---------------------+|sin(PI()/6)|+---------------------+|0.49999999999999994|+---------------------+1rowinset(0.00sec) ...
代码星球 ·2020-11-01

mysql cos() 函数
 mysql>selectcos(PI()/3);+--------------------+|cos(PI()/3)|+--------------------+|0.5000000000000001|+--------------------+1rowinset(0.00sec)//获取pimysq...
代码星球 ·2020-11-01

mysql abs() 获取绝对值
 mysql>selectabs(3-5);+----------+|abs(3-5)|+----------+|2|+----------+1rowinset(0.00sec) ...
代码星球 ·2020-11-01

mysql e的n次幂exp()
 mysql>selectexp(1);+-------------------+|exp(1)|+-------------------+|2.718281828459045|+-------------------+1rowinset(0.00sec) ...
代码星球 ·2020-11-01

mysql 生成随机数rand()
 mysql>selectrand();+--------------------+|rand()|+--------------------+|0.9913473352709294|+--------------------+1rowinset(0.00sec)mysql>selectrand(...
代码星球 ·2020-11-01

mysql 根据日期时间查询数据
 mysql>select*fromtable1;+----------+------------+-----+---------------------+|name_new|transactor|pid|order_date|+----------+------------+-----+-------...
代码星球 ·2020-11-01

mysql 创建时间字段
 altertabletable1addorder_datedatetimenull; mysql>select*fromtable1;+----------+------------+-----+------------+|name_new|transactor|pid|order_date...
代码星球 ·2020-11-01

mysql addtime() 函数
 mysql>selectaddtime('1997-12-3123:59:52','11:1:1');+--------------------------------------------+|addtime('1997-12-3123:59:52','11:1:1')|+-------------...
代码星球 ·2020-11-01

mysql adddate()函数
 mysql>selectadddate('1998-01-02',31);+---------------------------+|adddate('1998-01-02',31)|+---------------------------+|1998-02-02|+-----------------...
代码星球 ·2020-11-01

MySQL date_format() 函数
mysql>selectDATE_FORMAT(NOW(),'%c%d%Y%H:%i%p');+----------------------------------------+|DATE_FORMAT(NOW(),'%c%d%Y%H:%i%p')|+-------------------------------...
代码星球 ·2020-11-01

mysql 时间处理
 mysql>selectcurtime();+-----------+|curtime()|+-----------+|19:43:34|+-----------+1rowinset(0.00sec)mysql>selecttime(now());+-------------+|time(now...
代码星球 ·2020-11-01
首页上一页...406407408409410...下一页尾页
按字母分类： ABCDEFGHIJKLMNOPQRSTUVWXYZ其他