MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE doughnut_list (
    doughnut_name varchar(10),
    doughnut_type varchar(6),
    id int AUTO_INCREMENT PRIMARY KEY
);
SHOW CREATE TABLE doughnut_list;


Table
Create Table


doughnut_list
CREATE TABLE `doughnut_list` (
  `doughnut_name` varchar(10) DEFAULT NULL,
  `doughnut_type` varchar(6) DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci


ALTER TABLE `doughnut_list`
DROP PRIMARY KEY ;

Incorrect table definition; there can be only one auto column and it must be defined as a key


ALTER TABLE `doughnut_list`
    CHANGE COLUMN id id int DEFAULT 0,
    DROP PRIMARY KEY ;
SHOW CREATE TABLE doughnut_list;

Records: 0  Duplicates: 0  Warnings: 0




Table
Create Table


doughnut_list
CREATE TABLE `doughnut_list` (
  `doughnut_name` varchar(10) DEFAULT NULL,
  `doughnut_type` varchar(6) DEFAULT NULL,
  `id` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci