飘摇中的风雨

--SQLSERVER SELECT 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 () begin declare 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 @mo set @result = SUBSTRING(@str,floor(if(@mo=1,(@len+1)/2,...