/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 vote334 views1 answer
Update if else mysql
SQL
1 vote340 views2 answers
Setval max id postgresql sequence
SQL
8 votes364 views2 answers
Alert table name mysql
SQL
0 vote331 views1 answer
How much table store postgres
SQL
2 votes314 views1 answer
Oracle sql drop column if exists
SQL
0 vote325 views1 answer
Import mysql'
SQL
0 vote360 views1 answer
Materialized view redshift
SQL
1 vote373 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote366 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
1 vote320 views1 answer
Truncate table in postgresql and reset id
SQL