MariaDB [test]> CREATE SEQUENCE `account_service_seq` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 cache 2 nocycle ENGINE=InnoDB;

Query OK, 0 rows affected (0.143 sec)

MariaDB [test]> show create table account_service_seq\G

*************************** 1. row ***************************

       Table: account_service_seq

Create Table: CREATE TABLE `account_service_seq` (

  `next_not_cached_value` bigint(21) NOT NULL,

  `minimum_value` bigint(21) NOT NULL,

  `maximum_value` bigint(21) NOT NULL,

  `start_value` bigint(21) NOT NULL COMMENT 'start value when sequences is created or value if RESTART is used',

  `increment` bigint(21) NOT NULL COMMENT 'increment value',

  `cache_size` bigint(21) unsigned NOT NULL,

  `cycle_option` tinyint(1) unsigned NOT NULL COMMENT '0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed',

  `cycle_count` bigint(21) NOT NULL COMMENT 'How many cycles have been done'

) ENGINE=InnoDB SEQUENCE=1

1 row in set (0.000 sec)

MariaDB [test]> select now(), NEXTVAL(account_service_seq) ;

+---------------------+------------------------------+

| now()               | NEXTVAL(account_service_seq) |

+---------------------+------------------------------+

| 2021-05-20 12:22:42 |                            1 |

+---------------------+------------------------------+

1 row in set (0.001 sec)

MariaDB [test]> select now(), NEXTVAL(account_service_seq) ;

+---------------------+------------------------------+

| now()               | NEXTVAL(account_service_seq) |

+---------------------+------------------------------+

| 2021-05-20 12:24:19 |                            1 |

+---------------------+------------------------------+

1 row in set (0.003 sec)

MariaDB [test]> select now(), NEXTVAL(account_service_seq) ;

+---------------------+------------------------------+

| now()               | NEXTVAL(account_service_seq) |

+---------------------+------------------------------+

| 2021-05-20 12:24:23 |                            1 |

+---------------------+------------------------------+

1 row in set (0.004 sec)

MariaDB [test]> select now(), NEXTVAL(account_service_seq) ;

+---------------------+------------------------------+

| now()               | NEXTVAL(account_service_seq) |

+---------------------+------------------------------+

| 2021-05-20 12:24:24 |                            2 |

+---------------------+------------------------------+

1 row in set (0.001 sec)

MariaDB [test]> select now(), NEXTVAL(account_service_seq) ;

+---------------------+------------------------------+

| now()               | NEXTVAL(account_service_seq) |

+---------------------+------------------------------+

| 2021-05-20 12:24:29 |                            2 |

+---------------------+------------------------------+

1 row in set (0.000 sec)

MariaDB [test]> select now(), NEXTVAL(account_service_seq) ;

+---------------------+------------------------------+

| now()               | NEXTVAL(account_service_seq) |

+---------------------+------------------------------+

| 2021-05-20 12:24:44 |                            3 |

+---------------------+------------------------------+

1 row in set (0.003 sec)

MariaDB [test]> select now(), NEXTVAL(account_service_seq) ;

+---------------------+------------------------------+

| now()               | NEXTVAL(account_service_seq) |

+---------------------+------------------------------+

| 2021-05-20 12:24:47 |                            2 |

+---------------------+------------------------------+

1 row in set (0.000 sec)