/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

16 votes204 views6 answers
Install sqlite3 python
SQL
1 vote193 views1 answer
Add time to date sql
SQL
0 vote213 views1 answer
Mysql grant all on all databases
SQL
1 vote206 views1 answer
Postgres killing connections on db
SQL
0 vote197 views1 answer
Sql server order by nulls last
SQL
15 votes195 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote201 views1 answer
Sqlalchemy orm duplicate
SQL
1 vote200 views2 answers
Test sqlsrv connection
SQL
0 vote216 views1 answer
Check if mysql db is used
SQL
0 vote199 views1 answer
Odd record sql query
SQL