/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

16 votes168 views1 answer
CTE statement sql server
SQL
16 votes173 views3 answers
Update table from another table
SQL
0 vote181 views1 answer
Shows all databases created by user in ms sql
SQL
1 vote172 views1 answer
Mysql show queries running
SQL
0 vote213 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
12 votes171 views2 answers
Select into insert sql server
SQL
5 votes157 views2 answers
Oracle to_timestamp
SQL
2 votes179 views2 answers
Mysql alter column default
SQL
49 votes251 views6 answers
Get duplicate records in sql
SQL
1 vote161 views1 answer
Sql drop with dependencies
SQL