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
Was this helpful?
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
Was this helpful?