I found in both case it will work to create table but why data is getting remove when having connection property as create?

No need. Springboot has an embedded tomcat server. Just add the server port no. in your application.properties.
server.port=80

When I stop the server everytime data deleted from database. How can I solve this to keep the data in it ?

Use update instand if create

You mean in controller ?

In case if you are not using jpa then make sure you must added mysql drive and jdbc driver as well

Add the jdbc dependencies and run it again

It will work

Ok bro

You should use this spring.jpa.hibernate.ddl-auto=update instead of spring.jpa.hibernate.ddl-auto=create in application properties

Let’s say at very first if table is not available then also need to keep update?

I found in both case it will work to create table but why data is getting remove when having connection property as create?

it is complex to understand methods in spring boot

In case of create it will drop the table and create new one,
In case of update it will create the table if it does not exist

Ok thanks got the clarity

Anyone with 30 lpa package?

Hello can I ask sql doubt here??

Sure

30 lpa?

For this

Thanks…..in database there are already two tables and I have to create a relation between them….how to create that??

Using SQL workbench?

Is there any other option except sql workbenche

Why you want to know this? It’s confidential

I want to know what i have to do to achieve this within 2-3 years

I want to learn advanced java and Spring, can anyone suggest any u tube point to learn in an easy way😢

ERROR: insert or update on table “tt_hrms_asset” violates foreign key constraint “fk_hrms_asset_lookup_det_id_asset_name”
Detail: Key (lookup_det_id_asset_name)=(0) is not present in table “tm_cm_lookup_det”.
Where: SQL statement “INSERT
INTO hrms.tt_hrms_asset(
hrms_asset_id,

How to solve this error . when i save data i got this error
Look up I’d showing 0 i want look up I’d null .so how to pass null

check for <column_name> is null.

Ok i will check thanks sir ji

Application.properties

In this see 9th line