DEV Community

Discussion on: MariaDB Quick-tip #1 - Range of int

Collapse
 
darkain profile image
Vincent Milum Jr

This actually isn't needed in MariaDB, it has a built in feature called the "Sequence" engine.

For example, you can use the following query to get the exact same thing:

select * from seq_1_to_24;
Enter fullscreen mode Exit fullscreen mode

There are more complex queries supported too, such as every 3rd number rather than every number. mariadb.com/kb/en/sequence-storage...

Collapse
 
coderallan profile image
Allan Simonsen

Thanks a lot. I did not know about the Sequence Storage Engine.