CREATE SEQUENCE mysequence
INCREMENT 5
START 100;
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')*/
Code Example |
---|
Sql :: run sql script from command line |
Sql :: how to select random rows from table |
Sql :: drop function in sql |
Sql :: sqlite insert or update |
Sql :: recursion in sql |
Sql :: call postgres function |
Sql :: pl sql |
Sql :: pivot |
Sql :: c# select Mysql |
Sql :: PL SQL VARRAY of records |
Sql :: to_char oracle |
Sql :: sql update multiple rows |
Sql :: oracle select row max date |
Sql :: sql oracle update multiple rows |
Sql :: sql where part of string match |
Sql :: sql create table with data |
Sql :: oracle parameter |
Sql :: import data from csv to sql server |
Sql :: MySQL import data from large CSV file |
Sql :: consecutive numbers sql |
Sql :: deleting database in sql |
Sql :: mysql count unique in group statement |
Sql :: between |
Sql :: sql search all tables for attributes |
Sql :: SQL Modify Column in a Table -SQL Server |
Sql :: select into insert sql server |
Sql :: declare temp table in sql |
Sql :: how to find top 3 salary in sql |
Sql :: sql select whole row max column |
Sql :: set column width in sqlplus |