func_math.test
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:1k
源码类别:

MySQL数据库

开发平台:

Visual C++

  1. #
  2. # Test of math functions
  3. #
  4. select floor(5.5),floor(-5.5);
  5. select ceiling(5.5),ceiling(-5.5);
  6. select truncate(52.64,1),truncate(52.64,2),truncate(52.64,-1),truncate(52.64,-2);
  7. select round(5.5),round(-5.5);
  8. select round(5.64,1),round(5.64,2),round(5.64,-1),round(5.64,-2);
  9. select abs(-10), sign(-5), sign(5), sign(0);
  10. select log(exp(10)),exp(log(sqrt(10))*2);
  11. select pow(10,log10(10)),power(2,4);
  12. select rand(999999),rand();
  13. select pi(),sin(pi()/2),cos(pi()/2),abs(tan(pi())),cot(1),asin(1),acos(0),atan(1);
  14. select degrees(pi()),radians(360);