link200809的专栏

http://blog.youkuaiyun.com/mchdba/article/details/13922099

安装介质：Percona-Server-5.1.56-rel12.7-224-Linux-x86_64.tar.gz 安装环境：Linux umbidb02 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux 安装步骤： 建立数据安装目录：/mysql / 建立数据数据目录：/m

需求SQL 字段中的字符串拆成多行显示. 实现:MYSQL SUBSTRING_INDEX(COL1,'字符串分隔符号',位置) SQL: select  t2.help_topic_id as ID  ,SUBSTRING_INDEX(SUBSTRING_INDEX(RecordIdentifier,' ',t2.help_topic_id+1),' ',-1) as RecordIdent...

https://dev.mysql.com/doc/refman/5.5/en/