CREATE TABLE `books` (
`book_id` INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`book_name` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`author_name` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`book_type` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
)

أنتظر ردكم


ENGINE = innodb;