飘摇中的风雨

--SQLSERVERSELECT sysobjects.name AS 表名, syscolumns.name AS 列名, systypes.name AS 数据类型, syscolumns.length AS 数据长度 FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id I...

[code="sql"]grant all on *.* to root@'%' identified by 'password';-- 此处的password为实际密码,可替换[/code]

[code="sql"]DROP PROCEDURE test_insert ;DELIMITER ;;CREATE PROCEDURE test_insert ()begindeclare nid int;set nid=1;while nid

-- 只适用于每个数字只有1位的情况[code="sql"]set @str = '12345';set @len = LENGTH(@str);-- select @len;set @mo = mod(@len,2);-- select @moset @result = SUBSTRING(@str,floor(if(@mo=1,(@len+1)/2,...