/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

0 vote299 views1 answer
Provera dupliranih konatakata
SQL
0 vote350 views1 answer
Gcloud sql list databases
SQL
5 votes291 views2 answers
Oracle to_timestamp
SQL
0 vote314 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote311 views1 answer
Group by sql not ordering issues
SQL
0 vote308 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote317 views1 answer
How to select only id where is not in column mysql
SQL
0 vote351 views1 answer
Sql select without column name
SQL
5 votes275 views1 answer
Alter table default value mysql
SQL
0 vote291 views1 answer
Sql from null to not null
SQL