Sql integer to serial

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')*/

Similar codes

2 votes156 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote163 views1 answer
Enable sql server full text indexing
SQL
0 vote165 views1 answer
Oracle string length
SQL
16 votes168 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote159 views1 answer
Oracle apex run 404
SQL
0 vote155 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote115 views1 answer
Deleted table in sql trigger
SQL
0 vote170 views1 answer
Mysql aspas simples
SQL
0 vote144 views1 answer
Sqlite closes value
SQL
0 vote148 views1 answer
Postgresql isnull with max
SQL