MySQL-এ AUTO_INCREMENT কলামে PRIMARY KEY বাধ্যতামূলক কিনা?

টেবিল তৈরি (PRIMARY KEY সহ)

mysql> CREATE TABLE DemoTable (
    EmployeeId INT NOT NULL AUTO_INCREMENT,
    EmployeeName VARCHAR(40),
    EmployeeAge INT,
    PRIMARY KEY (EmployeeId),
    UNIQUE KEY (EmployeeName, EmployeeAge)
);

টেবিল স্ট্রাকচার

mysql> DESC DemoTable;
+--------------+-------------+------+-----+---------+----------------+
| Field        | Type        | Null | Key | Default | Extra          |
+--------------+-------------+------+-----+---------+----------------+
| EmployeeId   | int(11)     | NO   | PRI | NULL    | auto_increment |
| EmployeeName | varchar(40) | YES  | MUL | NULL    |                |
| EmployeeAge  | int(11)     | YES  |     | NULL    |                |
+--------------+-------------+------+-----+---------+----------------+

ডেটা ইনসার্ট (AUTO_INCREMENT স্বয়ংক্রিয়)

mysql> INSERT INTO DemoTable (EmployeeName, EmployeeAge) VALUES 
('Chris', 25), ('Robert', 34), ('Mike', 32);

ফলাফল:

+------------+--------------+-------------+
| EmployeeId | EmployeeName | EmployeeAge |
+------------+--------------+-------------+
|          1 | Chris        |          25 |
|          3 | Mike         |          32 |
|          2 | Robert       |          34 |
+------------+--------------+-------------+

নোট: AUTO_INCREMENT` কলাম অবশ্যই PRIMARY KEY` বা UNIQUE KEY` হয়ে থাকতে হবে।