{"rsdb":{"rid":"239900","subhead":"","postdate":"0","aid":"165300","fid":"57","uid":"1","topic":"1","content":"
\n

MySQL\u90e8\u5206\u6570\u636e\u51fd\u6570<\/p> \n \n \n \n \n \n <\/colgroup> \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
\u6570\u5b57\u51fd\u6570<\/td> \n \u529f\u80fd\u8bf4\u660e<\/td> \n <\/tr> \n
ABS(x)<\/td> \n \u8fd4\u56dex\u7684\u7edd\u5bf9\u503c<\/td> \n <\/tr> \n
\u67e5\u8be2<\/td> \n \u7ed3\u679c<\/td> \n <\/tr> \n
SELECT ABS(-23);<\/td> \n 23<\/td> \n <\/tr> \n
ACOS(x)<\/td> \n \u8fd4\u56dex\u7684\u53cd\u4f59\u5f26\u503c<\/td> \n <\/tr> \n
SELECT ACOS(0);<\/td> \n 1.570796328<\/td> \n <\/tr> \n
ASIN()<\/td> \n \u8fd4\u56dex\u4e0ey\u7684\u53cd\u6b63\u5f26\u503c<\/td> \n <\/tr> \n
SELECT ASIN(0.1)<\/td> \n 0.100167421<\/td> \n <\/tr> \n
ATAN(x,y)<\/td> \n \u8fd4\u56dex\u4e0ey\u7684\u53cd\u6b63\u5207\u503c<\/td> \n <\/tr> \n
SELECT ATAN(-2,2);<\/td> \n -0.7853981<\/td> \n <\/tr> \n
CEIL(x)<\/td> \n \u8fd4\u56de\u5927\u4e8e\u7b49\u4e8ex\u7684\u6700\u5c0f\u6574\u6570\u3002\u8fd4\u56de\u503c\u4e3aBIGINT<\/td> \n <\/tr> \n
SELECT CEIL(1.32);<\/td> \n 2<\/td> \n <\/tr> \n
COS(x)<\/td> \n \u8fd4\u56dex\u7684\u4f59\u5f26\u503c\uff0c\u4ee5\u5f27\u5ea6\u8ba1\u7b97<\/td> \n <\/tr> \n
SELECT COS(1);<\/td> \n 0.5403023<\/td> \n <\/tr> \n
COT(x)<\/td> \n \u8fd4\u56dex\u7684\u4f59\u5207\u503c<\/td> \n <\/tr> \n
SELECT COT(12);<\/td> \n -1.572673<\/td> \n <\/tr> \n
EXP(x)<\/td> \n \u8fd4\u56dee\u7684x\u6b21\u65b9<\/td> \n <\/tr> \n
SELECT EXP(-2);<\/td> \n 0.12533528<\/td> \n <\/tr> \n
FLOOR(x)<\/td> \n \u8fd4\u56de\u5c0f\u4e8e\u7b49\u4e8ex\u7684\u6700\u5927\u6574\u6570<\/td> \n <\/tr> \n
SELECT FLOOR(1.32);<\/td> \n 1<\/td> \n <\/tr> \n
FORMAT(x,y)<\/td> \n \u8f6c\u6362x\u4e3a\u6587\u672c\u5b57\u7b26\u4e32\u5e76\u56db\u820d\u4e94\u5165\u81f3y\u6307\u5b9a\u7684\u4f4d\u6570<\/td> \n <\/tr> \n
SELECT FORMAT(3452100.50, 2);<\/td> \n 3.452100.50<\/td> \n <\/tr> \n
LN(x)<\/td> \n \u8fd4\u56dex\u7684\u81ea\u7136\u5bf9\u6570<\/td> \n <\/tr> \n
SELECT LN(2);<\/td> \n 0.69314718<\/td> \n <\/tr> \n
LOG(x)\u4e0eLOG(x, y)<\/td> \n \u8fd4\u56dex\u7684\u81ea\u7136\u5bf9\u6570\uff0c\u82e5\u6709\u4e24\u4e2a\u53c2\u6570\uff0c\u5219\u4ee5x\u4e3a\u57fa\u6570\uff0c\u8fd4\u56dey\u7684\u5bf9\u6570<\/td> \n <\/tr> \n
SELECT LOG(2);<\/td> \n 0.69314718<\/td> \n <\/tr> \n
SELECT LOG(2, 65536);<\/td> \n 16<\/td> \n <\/tr> \n
MOD(x, y)<\/td> \n \u8fd4\u56dex\u9664\u4ee5y\u7684\u4f59\u6570<\/td> \n <\/tr> \n
SELECT MOD(249, 10);<\/td> \n 9<\/td> \n <\/tr> \n
PI()<\/td> \n \u8fd4\u56depi<\/td> \n <\/tr> \n
SELECT PI();<\/td> \n 3.141593<\/td> \n <\/tr> \n
POWER(x, y)<\/td> \n \u8fd4\u56dex\u7684y\u6b21\u65b9\u503c<\/td> \n <\/tr> \n
SELECT POW(3, 2);<\/td> \n 9<\/td> \n <\/tr> \n
RADIANS(x)<\/td> \n \u8fd4\u56dex\u4ece\u89d2\u5ea6\u8f6c\u6362\u6210\u5f27\u5ea6\u7684\u503c<\/td> \n <\/tr> \n
SELECT RADIANS(45);<\/td> \n 0.785398163<\/td> \n <\/tr> \n
RAND()<\/td> \n \u8fd4\u56de\u968f\u673a\u6d6e\u70b9\u6570<\/td> \n <\/tr> \n
SELECT RAND();<\/td> \n 0.846559207<\/td> \n <\/tr> \n
ROUND(x)<\/td> \n \u8fd4\u56dex\u56db\u820d\u4e94\u5165\u540e\u6700\u63a5\u8fd1\u7684\u6574\u6570<\/td> \n <\/tr> \n
SELECT ROUND(1.34);<\/td> \n 1<\/td> \n <\/tr> \n
SELECT ROUND(-1.34);<\/td> \n -1<\/td> \n <\/tr> \n
ROUND(x,y)<\/td> \n \u4ee5y\u6307\u5b9a\u7684\u5c0f\u6570\u4f4d\u6570\u5bf9x\u56db\u820d\u4e94\u5165<\/td> \n <\/tr> \n
SELECT ROUND(1.465, 1);<\/td> \n 1.5<\/td> \n <\/tr> \n
SELECT ROUND(1.465, 0);<\/td> \n 1<\/td> \n <\/tr> \n
SELECT ROUND(28.367, -1);<\/td> \n 30<\/td> \n <\/tr> \n
SIGN(x)<\/td> \n \u5f53x\u662f\u6b63\u6570\u65f6\uff0c\u8fd4\u56de1\uff1bx\u662f0\u65f6\uff0c\u8fd4\u56de0\uff1bx\u662f\u8d1f\u6570\u65f6\uff0c\u8fd4\u56de-1<\/td> \n <\/tr> \n
SELECT SIGN(-23);<\/td> \n -1<\/td> \n <\/tr> \n
SIN(x)<\/td> \n \u8fd4\u56dex\u7684\u6b63\u5f26\u503c<\/td> \n <\/tr> \n
SELECT SIN(PI());<\/td> \n 1.22E-16<\/td> \n <\/tr> \n
SQRT(x)<\/td> \n \u8fd4\u56dex\u7684\u5e73\u65b9\u6839<\/td> \n <\/tr> \n
SELECT SQRT(100);<\/td> \n 10<\/td> \n <\/tr> \n
TAN(x)<\/td> \n \u8fd4\u56dex\u7684\u6b63\u5207\u503c<\/td> \n <\/tr> \n
SELECT TAN(PI());<\/td> \n -1.22E-16<\/td> \n <\/tr> \n
TRUNCATE(x, y)<\/td> \n \u8fd4\u56dex\u622a\u65ad\u81f3y\u6307\u5b9a\u7684\u5c0f\u6570\u4f4d\u6570\u540e\u7684\u503c<\/td> \n <\/tr> \n
SELECT TRUNCATE(8.923, 1);<\/td> \n 8.9<\/td> \n <\/tr> \n <\/tbody> \n <\/table> \n
\n<\/div>","orderid":"0","title":"MySQL\u90e8\u5206\u6570\u636e\u51fd\u6570","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"161","pages":"1","comments":"0","posttime":"2017-10-20 08:14:19","list":"1508458459","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"MySQL<\/A> \u90e8\u5206<\/A> \u6570\u636e\u51fd\u6570<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"113.108.110.181","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"MySQL\u90e8\u5206\u6570\u636e\u51fd\u6570","lastview":"1712734862","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}