在MySQL中生成整数序列 [英] Generate an integer sequence in 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)
推荐答案
There is no sequence number generator (CREATE SEQUENCE) in MySQL. Closest thing is AUTO_INCREMENT
, which can help you construct the table.
这篇关于在MySQL中生成整数序列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文