1 Star 0 Fork 23

张福川/MYSQL常用内置函数

Create your Gitee Account
Explore and code with more than 13.5 million developers,Free private repositories !:)
Sign up
文件
This repository doesn't specify license. Please pay attention to the specific project description and its upstream code dependency when using it.
Clone or Download
07陈芳俊-3.sql 1.45 KB
Copy Edit Raw Blame History
陈芳俊 authored 2021-09-02 18:37 +08:00 . 作业
CREATE DATABASE Lianxi
use Lianxi
-- 数值型函数
/* 绝对值 abs
向上取整 ceil和ceiling
向下取整 floor
随机数 rand
四舍五入 round
*/
SELECT abs(-999) as 绝对值
SELECT ceil(3.14) as 向上取整
SELECT floor(3.14) as 向下取整
SELECT rand() as 随机数
SELECT round(3.14 , 1) as 四舍五入
-------- 字符串函数
SELECT LENGTH('asd123') as 字节长度
SELECT LENGTH('闽西') as 字节长度
SELECT CHAR_LENGTH('asd123') as 字符串长度
SELECT CHAR_LENGTH('闽西') as 字符串长度
SELECT REPLACE ('123456789','123456789','abcdefghi') as 替换
SELECT INSERT ('123456789',1,9,'abcdefghi') as 替换
SELECT LEFT ('123456789',5) as 从左所选数字截取
SELECT RIGHT ('123456789',5) as 从右所选数字截取
SELECT substr('123456789',3,5) as 从所选位置到指定位置截取
select CONCAT('123','abc') as 字符串拼接
SELECT LOWER('ABCDEF') as 转换为小写
SELECT UPPER('abcdef') as 转换为大写
SELECT REVERSE('123456789') as 逆序
SELECT TRIM(' 123 ') as 去除左右两边的空格
SELECT LTRIM(' 123 ') as 去除左边的空格
SELECT RTRIM(' 123 ') as 去除右边的空格
SELECT now() as 当前系统时间
SELECT year(now()) as 当前系统年份
SELECT time(now()) as 当前系统时间
SELECT FROM_UNIXTIME(1234567890)
SELECT UNIX_TIMESTAMP(now())
SELECT *,
if (
CASE xx -- 列名
WHEN 1 THEN
ELSE 2
END
)
from xxx
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/zhangfuchuang/mysql_lesson3.git
git@gitee.com:zhangfuchuang/mysql_lesson3.git
zhangfuchuang
mysql_lesson3
MYSQL常用内置函数
master

Search