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 vote331 views1 answer
Sql contains vs like
SQL
1 vote342 views1 answer
Top 10 rows in mysql
SQL
1 vote331 views1 answer
Get last week data in mysql
SQL
1 vote342 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
5 votes352 views1 answer
How to get all table names in sql query
SQL
4 votes346 views4 answers
Rollback in sql
SQL
1 vote326 views1 answer
Full sql mode
SQL
0 vote331 views1 answer
Sub query in linq
SQL
2 votes352 views2 answers
Sqlalchemy filter or
SQL
0 vote349 views1 answer
Hour differeence in mysql
SQL