大家好，又见面了，我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。
Jetbrains全系列IDE使用 1年只要46元 售后保障 童叟无欺
I would like to create a QUOTENAME() function in mySQL like the one that exists in M$ SQL Server.
This is what it does:
QUOTENAME returns a Unicode string with the delimiters added to make the input string a valid identifier. The QUOTENAME function uses this syntax:
QUOTENAME ( ‘string’ [ , ‘delimiter’ ] )
You pass QUOTENAME a string to be delimited and a one-character string to use as the delimiter. The delimiter can be a square bracket or a single or double quotation mark.
Is this even possible?
解决方案
You could start with something like this – building off of eggyal’s comment
DROP FUNCTION IF EXISTS QUOTENAME;
CREATE FUNCTION QUOTENAME (s varchar(50), d CHAR(1))
RETURNS VARCHAR(52)
RETURN CONCAT (d, REPLACE(s, d, CONCAT(d,d)), d);
And then add your special cases and additional functionality.
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/164261.html原文链接：https://javaforall.net
