/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

5 votes297 views1 answer
JBDC
SQL
1 vote277 views1 answer
Mysql find tables with column name
SQL
0 vote336 views1 answer
Error code 1451 sql
SQL
3 votes354 views2 answers
Oracle drop sequence
SQL
40 votes385 views4 answers
PostgreSQL add column
SQL
-1 vote291 views1 answer
Mysql delete duplicate rows except one
SQL
1 vote315 views1 answer
Select users with same username
SQL
0 vote346 views1 answer
Mysql streaming example
SQL
16 votes310 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote290 views1 answer
Limiting query result using where in sql
SQL