登峰造极境

  • WIN
    • CSharp
    • JAVA
    • OAM
    • DirectX
    • Emgucv
  • UNIX
    • FFmpeg
    • QT
    • Python
    • Opencv
    • Openwrt
    • Twisted
    • Design Patterns
    • Mysql
    • Mycat
    • MariaDB
    • Make
    • OAM
    • Supervisor
    • Nginx
    • KVM
    • Docker
    • OpenStack
  • WEB
    • ASP
    • Node.js
    • PHP
    • Directadmin
    • Openssl
    • Regex
  • APP
    • Android
  • AI
    • Algorithm
    • Deep Learning
    • Machine Learning
  • IOT
    • Device
    • MSP430
  • DIY
    • Algorithm
    • Design Patterns
    • MATH
    • X98 AIR 3G
    • Tucao
    • fun
  • LIFE
    • 美食
    • 关于我
  • LINKS
  • ME
Claves
长风破浪会有时,直挂云帆济沧海
  1. 首页
  2. Platforms
  3. LINUX
  4. Mysql
  5. 正文

Mysql函数-示例

2022-03-25

好像有几年没写函数了,写了一个,记录一下,便于后续粘贴。

CREATE DEFINER=`loud`@`%` FUNCTION `change_uid`(tname TEXT) RETURNS int
    DETERMINISTIC
BEGIN
	#Routine body goes here...
	declare i int;
	   set i=59;
     while i>9 do
         update cloud_factory.device set company_uuid = CONCAT("42708008-78c0-4a1b-a6bd-dd65683c1c",i) where company_uuid = CONCAT("42708008-78c0-4a1b-a6bd-dd65683c1cc",i);
         set i=i-1;
     end while;

	RETURN i;
END
标签: 暂无
最后更新:2022-03-25

代号山岳

知之为知之 不知为不知

点赞
< 上一篇
下一篇 >

COPYRIGHT © 2099 登峰造极境. ALL RIGHTS RESERVED.

Theme Kratos Made By Seaton Jiang

蜀ICP备14031139号-5

川公网安备51012202000587号