/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

0 vote446 views1 answer
How to check foreign key constraint in sql
SQL
0 vote372 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote354 views1 answer
Sql query interview questions githu
SQL
13 votes377 views1 answer
Sql join 3 tables on id
SQL
0 vote352 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote365 views2 answers
Athena drop partition
SQL
0 vote345 views1 answer
Sql server remove 0 from left
SQL
0 vote393 views1 answer
Postgresql check total storage
SQL
2 votes363 views2 answers
Run mysql command from bash
SQL
12 votes366 views1 answer
Docker mysql random root password
SQL