Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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

PREVIOUS NEXT
Code Example
Sql :: create table query in mysql 
Sql :: mysql get date from datetime 
Sql :: replace divide by zero error with 0 in sql 
Sql :: open postgresql.conf 
Sql :: is numeric in sql 
Sql :: sql convert datetime 
Sql :: invalid column name sql 
Sql :: sql server pivot rows to columns 
Sql :: how to delete all duplicate items in mysql 
Sql :: restore backup mysql .gz 
Sql :: to_char sql 
Sql :: ON DUPLICATE KEY UPDATE for postgres 
Sql :: mysql select row max date 
Sql :: sql 2nd highest salary 
Sql :: sql trim from string 
Sql :: sql use not in 
Sql :: sql delete where in 
Sql :: coalesce sql 
Sql :: for select oracle 
Sql :: SQL Rename Column in a Table 
Sql :: update select mysql 
Sql :: mysql changer nom table 
Sql :: mysql not empty 
Sql :: how to casting data types in postgresql 
Sql :: how to duplicate mysql table 
Sql :: sql insert values into table 
Sql :: insert in sql 
Sql :: max 3 salary in sql 
Sql :: restore backup "text" postgresql command line 
Sql :: mariadb create index if not exists 
ADD CONTENT
Topic
Content
Source link
Name
9+6 =