Loading... ```sql SELECT DATE_FORMAT(DATE_SUB(NOW(), INTERVAL xc YEAR), '%Y') as date FROM ( SELECT @xi:=@xi+1 as xc from (SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5) xc1, (SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5) xc2, (SELECT @xi:=-1) xc0 ) xcxc ``` 最后修改:2020 年 12 月 02 日 © 允许规范转载 赞 3 如果觉得我的文章对你有用,请随意赞赏