欢迎来到天天文库
浏览记录
ID:52960301
大小:1.17 MB
页数:193页
时间:2020-04-03
《SQL 函数参考手册.pdf》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、SQL函数参考手册Oracle、SQLServer、MySQL南無阿弥陀佛数据库系统自带函数..........................................................................................................................................................7字符函数.....................................................
2、.................................................................................................................7由字符获取ASCII码ASCII...............................................................................................................................7
3、格式化为ASCII字符串信息ASCIISTR(OracleOnly)..................................................................................7由字符获取UNICODE码................................................................................................................................
4、.8返回字符集CHARSET(MySQLOnly)..............................................................................................................8由ASCII码获取字符CHR/CHAR.......................................................................................................
5、...........8由UNICODE码获取字符NCHAR...................................................................................................................9字符串连接CONCAT
6、
7、/+.................................................................................................
8、................................9单词首字母大写INITCAP(OracleOnly)........................................................................................................10字符替换INSERT(MySQLOnly)........................................................................
9、...........................................10字符串搜索INSTR/CHARINDEX/LOCATE..............................................................................................11获取字符串左边开始指定个数的字符LEFT......................................................................
10、...........................12字符串长度LENGTH/LEN............................................................................................................................13加载文件LOAD_FILE(MySQLOnly)
此文档下载收益归作者所有