DB에서 자동증가 컬럼 만들기

 

MSSQL

CREATE TABLE table_name (
    id INT IDENTITY(1,1) PRIMARY KEY,
    ...
);

 

 

 

MYSQL

CREATE TABLE table_name (
    id INT AUTO_INCREMENT PRIMARY KEY,
    ...
);

 

 

 

POSTGRESQL

CREATE TABLE table_name (
    id SERIAL PRIMARY KEY,
    ...
);