![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MYSQL
kansong-crypto
这个作者很懒,什么都没留下…
展开
-
mysql字符串分割
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('7654,7698,7782,7788',',',help_topic_id+1),',',-1) AS num FROM help_topic_copy WHERE help_topic_id < LENGTH('7654,7698,7782,7788')-LENGTH(REPLACE('7654,7698,7782,7788',',',''))+1注意:help_topic_copy 是复制mysql库下的h原创 2021-08-18 21:30:17 · 1324 阅读 · 0 评论 -
mysql使用rank()函数排序
一、创建表CREATE TABLE `players` ( `pid` INT(2) NOT NULL AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, `age` INT(2) NOT NULL, PRIMARY KEY (`pid`), UNIQUE KEY `name` (`name`)) ENGINE=INNODB DEFAULT CHARSET=latin1;INSERT INTO `players` (`pid`, `name`原创 2021-08-18 20:53:02 · 1290 阅读 · 0 评论