/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 vote319 views1 answer
Mysql get last insert id
SQL
1 vote355 views1 answer
Query for all indexes in table postgres
SQL
1 vote364 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
-1 vote345 views2 answers
On update cascade
SQL
1 vote356 views3 answers
SELECT * FROM
SQL
2 votes377 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote340 views2 answers
Database owner can't create new tables postgres
SQL
1 vote315 views1 answer
Unique vs distinct sql
SQL
0 vote370 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote358 views1 answer
Mysql multiple count
SQL