/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 vote203 views5 answers
Postgresql difference between two dates in days
SQL
12 votes191 views2 answers
Insert multiple rows from another table sql
SQL
0 vote182 views1 answer
Ms sql database data size
SQL
0 vote195 views1 answer
Group_concat only returns one row
SQL
0 vote188 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
6 votes190 views4 answers
Sqlite drop table
SQL
0 vote217 views3 answers
Sql drop all tables
SQL
0 vote213 views1 answer
Add mysql database to power bi web
SQL
1 vote186 views1 answer
How to start with sql
SQL
0 vote244 views1 answer
Openquery join two tables
SQL