21. Create mapping tables | Spring boot tutorials | Code Simple
Hello Everyone, In this video, we will create two tables in MySql.
Using this we will learn intermediate tutorials in upcoming videos.
SQL Script:
-- author
CREATE TABLE `author` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`gender` varchar(15) DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
book_author
CREATE TABLE `book_author` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`book_id` bigint(20) NOT NULL,
`author_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_book_author__book_id` (`book_id`),
KEY `fk_book_author__author_id` (`author_id`),
CONSTRAINT `fk_book_author__author_id` FOREIGN KEY (`author_id`) REFERENCES `author` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_book_author__book_id` FOREIGN KEY (`book_id`) REFERENCES `book` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1
Github Repo:
https://github.com/cbesangeeth/book-s...
#Share #Comment and #Like
On this page of the site you can watch the video online 21. Create mapping tables | Spring boot tutorials | Code Simple with a duration of hours minute second in good quality, which was uploaded by the user Code Simple 19 January 2020, share the link with friends and acquaintances, this video has already been watched 8,301 times on youtube and it was liked by 65 viewers. Enjoy your viewing!
