Sql sequence

CREATE SEQUENCE seq_tipo MINVALUE 1;
ALTER TABLE tipo 
ALTER codt SET DEFAULT nextval('seq_tipo');

/*insert into YOUR_COLUMN_NAME VALUES (nextval('seq_tipo'), 'value_2')*/

Sql sequence

CREATE SEQUENCE sequence-name
    START WITH initial-value
    INCREMENT BY increment-value
    MAXVALUE maximum-value
    CYCLE | NOCYCLE;

Source: studytonight.com

Similar codes

0 vote284 views1 answer
How to create a table in sql stack overflow
SQL
1 vote293 views2 answers
Sql queries practice
SQL
6 votes285 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote294 views1 answer
Setval in postgres
SQL
0 vote279 views1 answer
Sql last 7 days
SQL
8 votes309 views1 answer
Racle create auto increment column
SQL
0 vote291 views1 answer
Mysql shell ERROR: Not connected.
SQL
21 votes303 views3 answers
Sql server search column name in all tables
SQL
0 vote275 views1 answer
Download mysql database to excel in android studio
SQL
0 vote245 views1 answer
Delete all rows from table sqlite
SQL