jiangjiangxiaooo的博客

MySql将用函数总结及Sharding分库分表一、单行函数一、字符函数1. length 获取参数值的字节个数SELECT LENGTH('john');SELECT LENGTH('张三丰hahaha');SHOW VARIABLES LIKE '%char%'2. concat 拼接字符串SELECT CONCAT(last_name,'_',first_name) 姓名 FROM employees;3. upper、lowerSELECT UPPER('john');S