在MySQL中生成整数序列

本文介绍了在MySQL中生成整数序列的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我需要对表/结果集/任何具有整数n至m(含)的连接.有没有简单的方法就可以不用构建表就可以做到这一点?

I need to do a join with a table/result-set/whatever that has the integers n to m inclusive. Is there a trivial way to get that without just building the table?

(顺便说一句，这种类型的结构称为"元查询"吗?)

(BTW what would that type of construct be called, a "Meta query"?)

m-n被限制在合理的范围内(小于1000)

m-n is bounded to something reasonable ( < 1000's)

推荐答案

没有序列号生成器(创建序列).最接近的是AUTO_INCREMENT，它可以帮助您构造表.

There is no sequence number generator (CREATE SEQUENCE) in MySQL. Closest thing is AUTO_INCREMENT, which can help you construct the table.