在 MySQL 中生成整数序列

2021-11-20 00:00:00 mysql

我需要与一个表/结果集/任何具有整数 nm 的连接进行连接.有没有一种简单的方法可以在不构建表格的情况下获得它?

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.

相关文章