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

14 votes324 views4 answers
Sql compiler
SQL
0 vote274 views2 answers
Mysql disable foreign key checks
SQL
0 vote328 views1 answer
New rails app with mysql
SQL
0 vote296 views1 answer
Sql select random procentage from rows
SQL
0 vote281 views1 answer
IIF
SQL
1 vote287 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote307 views1 answer
In query in sql
SQL
23 votes312 views4 answers
Uninstall postgresql ubuntu
SQL
1 vote288 views1 answer
Float precision in psql
SQL
1 vote292 views2 answers
List tables sqlalchemy
SQL