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 vote338 views1 answer
Get id if is not equal in certain table
SQL
0 vote333 views1 answer
Mysql loop through databases and execute query
SQL
4 votes341 views2 answers
Sql offset
SQL
4 votes320 views1 answer
Sql group by year
SQL
0 vote358 views1 answer
Bitmap join index
SQL
4 votes322 views2 answers
Oracle sql group by date year
SQL
0 vote334 views2 answers
Advantages of stored procedures sql
SQL
14 votes343 views3 answers
Trim sql
SQL
1 vote321 views1 answer
Xampp import sql file command line
SQL
2 votes325 views1 answer
Add new column not null sql server
SQL