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

45 votes345 views5 answers
Grant all privileges mysql
SQL
0 vote298 views1 answer
Order child below the parent in mysqli
SQL
0 vote280 views1 answer
Commit transaction sql
SQL
2 votes282 views2 answers
Sql query to copy data from one column to another
SQL
0 vote279 views1 answer
Sql datediff db2
SQL
0 vote298 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote282 views1 answer
Select from column mysql
SQL
0 vote277 views1 answer
Mssql now diff 90 day
SQL
0 vote276 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote281 views1 answer
If column value is null then in mysql
SQL