how to craete a database for library with primary key auto increment in mysql code example

Example: create table primary key auto increment mysql

define primary key auto increment