/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

2 votes138 views2 answers
Null column to 0 in mysql
SQL
0 vote135 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote121 views1 answer
How to create a table in sql stack overflow
SQL
8 votes121 views1 answer
Insert a select statement into a table
SQL
13 votes117 views2 answers
Sql join
SQL
1 vote176 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote73 views1 answer
Oracle sql replace string in clob
SQL
0 vote113 views2 answers
Database owner can't create new tables postgres
SQL
0 vote113 views1 answer
Logtash mysql cofiguration file
SQL
0 vote106 views2 answers
Mysql select date from datetime
SQL