Custom Query in Spring Boot with Mysql database tutorial | Spring Data JPA | Query Param annotations

How to write and use custom query in spring boot while connecting to mysql database is shown
#springboot #springboottutorial

[@raghucreations943]

That's just what I'm looking for, thanks a lot. I've learned a lot from your content. Thank You sir....

[@unitedtoptech6288]

You are most welcome sir !! all the best

[@somnathchoudhuri]

Useful lecture. Some suggestions - add 2 or 3 tables and joins. Also add multi params. Thanks for this!

[@unitedtoptech6288]

Great suggestion! cool

[@TheKnightKing007]

it is really help full for me...plz make more advanced videos

[@unitedtoptech6288]

Sure!! Thank you

[@eyobedmesfin7260]

nice tutorial 👍👍

[@unitedtoptech6288]

Thank you! Cheers!

[@nishantchowdhury4350]

so good

[@unitedtoptech6288]

thanks

[@bsnbhasith5666]

thank you sir

[@unitedtoptech6288]

Most welcome sir

[@hplat-vku]

30:34 the reason

[@unitedtoptech6288]

cool

[@mr.anilkumar5418]

how can we insert the data through custom query?

[@unitedtoptech6288]

You can have a insert query and pass the values to be inserted when calling the query function

[@Taranpreet_singho]

bro how check phone number present then return yes present else not how to wriite this ????

[@unitedtoptech6288]

Is phone number some column value in table?

[@Taranpreet_singho]

​@@unitedtoptech6288 yes bro phonenumber is column Please give me solution

[@Taranpreet_singho]

​@@unitedtoptech6288If phone is not present then return 500 error

[@unitedtoptech6288]

You can just have a custom select query with where phoneNumber="input number" , since phone number is unique we will get only one record and if the phone number is not there in table return error

[@tompol5433]

add github link for you project

[@unitedtoptech6288]

Will do in future