SELECT LEFT(id,4) as 年,RIGHT(id,2) as 月 FROM 表
SELECT SUBSTRING(id,1,4) as 年,SUBSTRING(id,5,2) as 月 FROM 表
substr 截取