SQL

create table sql server auto increment primary key

/* mysql server */
CREATE TABLE persons (
    id int NOT NULL AUTO_INCREMENT,
    colour varchar(191) NOT NULL,
    created datetime, 
    modifed datetime
);

/* sql server IDENTITY*/
CREATE TABLE persons (
    id int IDENTITY(1,1) PRIMARY KEY,
    colour varchar(191) NOT NULL,
    created datetime, 
    modifed datetime
);

INSERT INTO persons (colour, created, modified)
VALUES ('red','2022-08-05', '2022-08-05'),
VALUES ('green','2022-08-05', '2022-08-05'),
VALUES ('blue','2022-08-05', '2022-08-05');

create table with primary key auto increment in sql

CREATE TABLE table_name (
    id INT NOT NULL IDENTITY(1, 1),
    name NVARCHAR (100) NULL,
    school NVARCHAR (100) NULL,
    PRIMARY KEY (ID)
);

sql create tabel with primary key auto_increment code

CREATE TABLE books (
  id              INT           NOT NULL    IDENTITY    PRIMARY KEY,
  title           VARCHAR(100)  NOT NULL,
  primary_author  VARCHAR(100),
);