{"id":1280,"date":"2018-09-21T16:18:37","date_gmt":"2018-09-21T08:18:37","guid":{"rendered":"http:\/\/www.iooe.cn\/?p=1280"},"modified":"2018-09-21T16:18:37","modified_gmt":"2018-09-21T08:18:37","slug":"mysql-this-function-has-none-of-deterministic-no-sql-%e9%94%99%e8%af%af1418-%e7%9a%84%e5%8e%9f%e5%9b%a0%e5%88%86%e6%9e%90%e5%8f%8a%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95-%e8%bd%ac","status":"publish","type":"post","link":"https:\/\/www.iooe.cn\/index.php\/2018\/09\/21\/mysql-this-function-has-none-of-deterministic-no-sql-%e9%94%99%e8%af%af1418-%e7%9a%84%e5%8e%9f%e5%9b%a0%e5%88%86%e6%9e%90%e5%8f%8a%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95-%e8%bd%ac\/","title":{"rendered":"MySQL This function has none of DETERMINISTIC, NO SQL&#8230;\u9519\u8bef1418 \u7684\u539f\u56e0\u5206\u6790\u53ca\u89e3\u51b3\u65b9\u6cd5 (\u8f6c)"},"content":{"rendered":"<h2>\n\t<a href=\"https:\/\/www.cnblogs.com\/xihong2014\/p\/5566383.html\" id=\"cb_post_title_url\">MySQL This function has none of DETERMINISTIC, NO SQL&#8230;\u9519\u8bef1418 \u7684\u539f\u56e0\u5206\u6790\u53ca\u89e3\u51b3\u65b9\u6cd5 (\u8f6c)<\/a><br \/>\n<\/h2>\n<p>\n\t<strong>\u89e3\u51b3\u65b9\u6cd5\uff1a<\/strong>\n<\/p>\n<p>\n\t\u89e3\u51b3\u529e\u6cd5\u4e5f\u6709\u4e24\u79cd\uff0c \u7b2c\u4e00\u79cd\u662f\u5728\u521b\u5efa\u5b50\u7a0b\u5e8f(\u5b58\u50a8\u8fc7\u7a0b\u3001\u51fd\u6570\u3001\u89e6\u53d1\u5668)\u65f6\uff0c\u58f0\u660e\u4e3aDETERMINISTIC\u6216NO SQL\u4e0eREADS SQL DATA\u4e2d\u7684\u4e00\u4e2a\uff0c \u4f8b\u5982: CREATE DEFINER = CURRENT_USER PROCEDURE `NewProc`() &nbsp;&nbsp;&nbsp; DETERMINISTIC BEGIN #Routine body goes here&#8230; END;;\n<\/p>\n<p>\n\t\u7b2c\u4e8c\u79cd\u662f\u4fe1\u4efb\u5b50\u7a0b\u5e8f\u7684\u521b\u5efa\u8005\uff0c\u7981\u6b62\u521b\u5efa\u3001\u4fee\u6539\u5b50\u7a0b\u5e8f\u65f6\u5bf9SUPER\u6743\u9650\u7684\u8981\u6c42\uff0c\u8bbe\u7f6elog_bin_trust_routine_creators\u5168\u5c40\u7cfb\u7edf\u53d8\u91cf\u4e3a1\u3002\n<\/p>\n<p>\n\t\u8bbe\u7f6e\u65b9\u6cd5\u6709\u4e09\u79cd:\n<\/p>\n<p>\n\t1.\u5728\u5ba2\u6237\u7aef\u4e0a\u6267\u884cSET GLOBAL log_bin_trust_function_creators = 1;\n<\/p>\n<p>\n\t2.MySQL\u542f\u52a8\u65f6\uff0c\u52a0\u4e0a&#8211;log-bin-trust-function-creators\u9009\u8d24\uff0c\u53c2\u6570\u8bbe\u7f6e\u4e3a1\n<\/p>\n<p>\n\t3.\u5728MySQL\u914d\u7f6e\u6587\u4ef6my.ini\u6216my.cnf\u4e2d\u7684[mysqld]\u6bb5\u4e0a\u52a0log-bin-trust-function-creators=1\n<\/p>\n<p>\n\t\u6709\u6548\u679c\uff1a\n<\/p>\n<p>\n\tDELIMITER $$ USE `dbname`$$ DROP FUNCTION IF EXISTS `plus`$$ CREATE FUNCTION `plus`(var1 FLOAT,var2 FLOAT ,var3 FLOAT) RETURNS FLOAT(18,6) BEGIN SELECT (var1-var2)+var3 INTO @result ; RETURN @result; &nbsp; &nbsp; END$$ DELIMITER ;\n<\/p>\n<p>\n\t&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL This function has none of DETERMINISTIC, NO SQL&#8230;\u9519\u8bef1418 \u7684\u539f\u56e0\u5206\u6790\u53ca\u89e3\u51b3\u65b9\u6cd5 (\u8f6c&#8230; <\/p>\n<div class='button-mores'><a href='https:\/\/www.iooe.cn\/index.php\/2018\/09\/21\/mysql-this-function-has-none-of-deterministic-no-sql-%e9%94%99%e8%af%af1418-%e7%9a%84%e5%8e%9f%e5%9b%a0%e5%88%86%e6%9e%90%e5%8f%8a%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95-%e8%bd%ac\/'> \u9605\u8bfb\u66f4\u591a&#8230; <\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/www.iooe.cn\/index.php\/wp-json\/wp\/v2\/posts\/1280"}],"collection":[{"href":"https:\/\/www.iooe.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iooe.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iooe.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iooe.cn\/index.php\/wp-json\/wp\/v2\/comments?post=1280"}],"version-history":[{"count":1,"href":"https:\/\/www.iooe.cn\/index.php\/wp-json\/wp\/v2\/posts\/1280\/revisions"}],"predecessor-version":[{"id":1281,"href":"https:\/\/www.iooe.cn\/index.php\/wp-json\/wp\/v2\/posts\/1280\/revisions\/1281"}],"wp:attachment":[{"href":"https:\/\/www.iooe.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iooe.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iooe.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}