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

0 vote345 views1 answer
How to use select union and loop
SQL
0 vote352 views4 answers
Mysql count table rows
SQL
4 votes434 views1 answer
How to check last gather stats on table in oracle
SQL
8 votes362 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote325 views1 answer
Postgres float to int
SQL
2 votes370 views1 answer
Metasploit start postgresql
SQL
3 votes362 views1 answer
APEX elapsed time
SQL
4 votes332 views2 answers
Error loading MySQLdb module.
SQL
2 votes384 views1 answer
Create mysql user on all hosts
SQL
0 vote347 views1 answer
Window function to forward fill
SQL