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:

#Share #Comment and #Like

[sk_editzz]

updated version ku video upload pannunga

[manikandan-ozqy]

Hi, All videos is very clear and useful to every one. Thanks lot for your effort

[OsGamesX]

just a suggestion if you add
jpa:
show-sql: true
generate-ddl: true
hibernate:
ddl-auto: create

on applicaton.yml then hibernate will create all tables on database u need just create a database name on phpmyadmin

[manikandan-ozqy]

Before Start your Video i don't know about spring, springboot. Now i am very happy to say i have a confident of my level. Thanks Lot . can you please upload more videos and Interview points also

[nirosh_an]

Bro how to create multiple tables without using mapping table

[manikandan-ozqy]

It is possible can you please upload Springboot Microservices, Its very helpful to every one. Who are all coming from basis level.

[manikandan-ozqy]

We expecting more videos on Spring Intermediate and if it complete, please upload Expert video. We are waiting for your valuable videos. The main reason Tamil Explanation.

[subramanianchenniappan]

I will see all your videos . I am a java developer for many years. Now doing an android project for a freelance gig with a no SQL db instead of MySQL and using restful api . இந்த வீடியோ ஏதாவது play list ல போட்டிருக்கீங்களா. Thanks. Ok . Just saw that springboot videos numbered 20 onwards are not in playlist . Will you explain entire project. Thanks again . Nobody explained to this extent bro

[aniss]

please make a spring series with english sub.., i do really appreciate you thanks before