CHECK

CREATE TABLE IF NOT EXISTS `book`(
	`book_id` CHAR(12) NOT NULL,
	`book_name` VARCHAR(40) NOT NULL,
	`book_subject` VARCHAR(4) NOT NULL,
	`book_page` INT(11) NOT NULL CHECK(`book_page`>0)
)

Last updated