/SQL/Sql create tabel with primary key auto_increment code

Sql create tabel with primary key auto_increment code

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

1 vote182 views1 answer
Show table status command in mysql
SQL
0 vote208 views1 answer
Duplicate value unique constraint mysql error
SQL
15 votes182 views2 answers
Sql order by multiple columns
SQL
0 vote186 views1 answer
Sql find record cannot cast date
SQL
0 vote202 views1 answer
Hashpass
SQL
1 vote185 views1 answer
Postgresql filter on
SQL
0 vote135 views1 answer
Oracle function select into
SQL
2 votes157 views1 answer
Ifnull postgres
SQL
6 votes165 views2 answers
Find mysql version linux
SQL
0 vote139 views1 answer
Connection error in mysql workbench
SQL