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 vote176 views1 answer
Oracle query archive mode
SQL
16 votes187 views1 answer
Mysql mediumint max value
SQL
0 vote199 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote182 views1 answer
Datetime postgres typeorm
SQL
5 votes166 views2 answers
Create table
SQL
-1 vote183 views1 answer
Mysql order by on condition
SQL
0 vote193 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote194 views1 answer
Add SuperUser MySQL
SQL
0 vote234 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
5 votes248 views1 answer
How to get all table names in sql query
SQL