Table Books
isbn varchar 20
title varchar 70
author varchar 50
price float -
DROP TABLE IF EXISTS `test`.`books`;
CREATE TABLE `test`.`books` (
`isbn` varchar(20) NOT NULL,
`title` varchar(70) NOT NULL,
`author` varchar(50) NOT NULL,
`price` float NOT NULL,
PRIMARY KEY (`isbn`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;