Error de SQL (1075): Incorrect table definition; there can be only one auto column and it must be defined as a keyuery sql heidi code example

Example: there can be only one auto column and it must be defined as a key

CREATE TABLE book (
   id INT AUTO_INCREMENT NOT NULL,
   accepted_terms BIT(1) NOT NULL,
   accepted_privacy BIT(1) NOT NULL,
   primary key (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;