在 MySQL 中生成整数序列 [英] Generate an integer sequence in 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's)

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

推荐答案

没有序列号生成器 (CREATE SEQUENCE) 在 MySQL 中.最接近的是AUTO_INCREMENT，它可以帮助您构建表格.

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

这篇关于在 MySQL 中生成整数序列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！