/SQL/Create table with primary key auto increment in sql

Create table with primary key auto increment in sql

How to auto increment in sql

CREATE TABLE Persons (
    Personid int NOT NULL AUTO_INCREMENT,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (Personid)
);
INSERT INTO Persons (FirstName,LastName)
VALUES ('Lars','Monsen');

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),
);

Source: chartio.com

Similar codes

7 votes135 views1 answer
Sql management studio display line numbers
SQL
0 vote133 views1 answer
Drop all tables db2
SQL
0 vote139 views1 answer
Criteria builder select subset of column
SQL
0 vote130 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
7 votes165 views4 answers
Mysql delete older duplicates
SQL
0 vote271 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote204 views1 answer
Trigger
SQL
0 vote144 views1 answer
Join in update query in mysql
SQL
0 vote200 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
1 vote140 views1 answer
Load sql into mamp
SQL