CREATE TABLE `book_202151028` (
  `no` int(11) NOT NULL,
  `book name` varchar(32) NOT NULL,
  `author` char(16) NOT NULL,
  `publisher` varchar(20) NOT NULL,
  `Year of publication` varchar(30) NOT NULL,
  `ISBN` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `book_202151028`
  ADD PRIMARY KEY (`no`);

ALTER TABLE `book_202151028`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;