在 MySQL 中生成整数序列
2021-11-20 00:00:00
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.
相关文章