How can i create a database with a table wich has 'id' column and 'id' will be auto increment.

Answer 1

CREATE TABLE tableName(id int NOT NULL AUTO_INCREMENT)

Answer 2

CREATE DATABASE dbName

USE dbName

CREATE TABLE tableName (id int NOT NULL AUTO_INCREMENT)

execute these one by one