POST data in Mysql database using Spring Boot and Postman tutorial | REST API

POST data in Mysql database using Spring Boot and Postman tutorial | REST API


POST data in Mysql database using Spring Boot and Postman tutorial | REST API

How to perform post operation to input data into mysql database in rest api using spring boot and postman is shown

#restapi #mysql #springboot


Content

0.3 -> hi everyone in this video I will be showing  you how to post data in mySQL database by  
6.3 -> using spring boot backend as well as Postman  so let's get started first thing what you want  
11.58 -> to do is you will just go to your browser and  need to search for spring initializer you'll  
16.08 -> be getting this first link over here spring  initializer just click it and here you need  
20.64 -> to add the dependencies as well as the name  of your project and the versions so I will go  
24.96 -> with Gradle groovy that is fine language is  Java and let me just now change the name as  
31.32 -> spring Pro something like that you can just give  it to everywhere yeah you can just paste it and  
37.26 -> you can just change it here as well yeah this  is totally up to your choice and jar is fine and  
42.78 -> Java 17 works for me so these are fine now so we  will be using some dependencies over here so just  
47.88 -> click on add dependency and first thing we need  to search for spring web just add it spring web  
54.72 -> and I'll click again add dependency and next one  is going to be the spring data jpa so it's going  
60.36 -> to be spring data JPA here we will be having  and I will add the MySQL driver as well MySQL  
67.56 -> driver and final one is going to be lombok the  reason why I'm adding lombok is because we don't  
72.12 -> want to like manually create the Getters and  Setters or the constructors we can just use  
76.14 -> the annotations present inside lombok so these  are basically the four dependencies that I am  
80.28 -> adding so this is the entire stuff all right so  once you are done creating all these you would  
85.32 -> just click on generate so it will be getting  downloaded in the form of a zip file so here  
90.66 -> you can see right spring Pro so now let me just  go to my downloads folder so here you can see  
95.7 -> it is in the form of a win rar zip file so just  right click it and just click on extract files
105 -> and just click on OK so it will be  getting extracted over here itself  
108.54 -> yeah so here you can see this is the file we'll be  
111.42 -> having source and main.test so this  is the dot Java file over here yeah
118.62 -> so this is the file so now let me just open this  particular folder as a project in IntelliJ so for  
124.44 -> that just go to IntelliJ IDEA and after opening  intellij idea you need to go to file and need to  
129.6 -> go to open and need to go to downloads and  here you will be having the spring Pro the  
134.82 -> spring project okay just click on that and click  on OK and just click on this window so at first it  
141.96 -> will take some time to load so just be patient  I think it will take some time for indexing as  
146.64 -> well as the Gradle to build so just be patient  at first so here you can see it will be showing  
152.76 -> you updating index and importing Gradle so  Gradle build so these two process are really  
157.26 -> important and you need to like wait for some time  until both the processes are getting completed
163.62 -> so here you can see now all the processes have  been now completed and there is no loading or  
167.76 -> anything like that so first thing what we  need to do is we will be just going to my  
171.54 -> main Java and here you can see this is my main  application over here so now we will be making  
177.48 -> some changes in application.properties so for  that where we need to go is resources and here  
183.06 -> you will be having application dot properties just  double click it and here you will be having the  
187.08 -> application.properties so first we will be adding  our local URL of our mySQL database so it's going  
193.38 -> to be spring Dot data source dot URL equal to  jdbc colon MySQL colon // Local Host colon 3306
218.34 -> slash and next you need to specify your  database name if that is going to be present  
223.08 -> in your MySQL workbench so I will just name  it as new DB and you have to specify colon  
228.36 -> 3306 because this is not like the random  port number this is the port number where  
232.02 -> MySQL workbench is running so be specific  to that so once you're added your database  
237.3 -> you have to create this particular database in  MySQL workbench otherwise it will throw you an  
241.32 -> error so I will just go to my MySQL workbench  and create this particular database new DB  
247.56 -> and if I just now refresh it over here I'll  be having the database created so this is  
251.82 -> fine our next thing we need to specify  the username and password of your mySQL  
256.68 -> database so let me just now copy this thing  so it's going to be spring dot data source Dot  
264.06 -> username and specify the username which is root  for me this may vary from person to person and  
270.42 -> again spring dot data source Dot password  so you need to specify your password let me  
277.62 -> specify mine so this is fine these are some of  the credentials that we need to give over here  
281.94 -> so after this we will be using some connections  or properties for our connection so it's going  
286.86 -> to be spring dot jpa dot show hyphen SQL equal  to true so this command is basically like used  
295.92 -> to display the sql command in our console so  I told you like we will be creating a table  
301.38 -> at the end so the creation of that particular  table and its SQL command will be displayed  
305.46 -> at the console so that's the reason why we are  adding this particular property and next thing  
309.48 -> are going to be some of the default properties  okay it's going to be spring dot jpa dot generate
318.48 -> and hyphen ddl equal to true next one is going to  be spring dot jpa dot hibernate Dot ddl Dot Auto
337.08 -> equal to update and final thing let me just  now copy this and paste it Dot properties Dot  
350.76 -> hibernate Dot dialect equal to org Dot you'll  be having hibernate dot dialect dot MySQL8
373.74 -> Dialect okay so here you need to be careful  m is capital Y is small SQL are caps 8 D is  
380.64 -> capital and dialect I so once you're done adding  all the values in application.properties you need  
386.1 -> to come to the folder where you have your main  spring application okay so by default the name  
390.6 -> would be com dot it'll be your project name okay  so you want to just right click over here and we  
396.6 -> will be adding like four folders or directory so  the names of the folders is going to be entity  
402 -> repository controller and service okay so it'll  sound confusing I will just create them first  
407.04 -> so it's going to be new and here we'll be having  option called as package over here just click it  
414.48 -> so first we will be creating the  entity folder okay just capital e  
418.74 -> type entity just hit enter okay so after that  we'll be getting this entity so don't make any  
424.02 -> changes okay don't rewrite that particular thing  okay so again after right clicking I will be going  
428.34 -> with package so what I meant was here will be  having a DOT okay so don't just remove that and  
433.62 -> next thing is going to be the Repository yeah and  next one is going to be controller and the service  
442.92 -> it's going to be the service so it's not  necessary to have like this folder structure  
447.6 -> but it's always good to implement so it's more  easy to read your code in companies generally  
452.1 -> they will have this way so it's always better  to practice having separate folders for each  
456.06 -> purpose of your file so the final one is going to  be our controller so it's going to be controller  
463.5 -> yeah so first we will be starting with the  entity so entity basically will have the  
468.3 -> Java file in which we will specify our table as  well as its columns and its data members okay  
473.52 -> so just click on entity right click new you will  be having this Java class click that I will name  
480.48 -> the class name as student because I'm just going  to like input student details as a demo purpose  
485.28 -> enter this class name you can enter whatever you  want after that just click on class and hit enter  
491.46 -> so here we'll be having the student class created  for us so through this class we will be able to  
496.2 -> add properties and column names for our table  that we're going to create in our MySQL okay so  
502.2 -> just imagine this as a class representation of  a table okay basically that's it so first let  
507.12 -> me add the column names okay after that I will go  and annotating the particular main class so it's  
512.52 -> going to be I will have here three columns which  is ID Mark and name so it's going to be private  
520.44 -> have it as int ID so this is going to be  like the primary key the unique key yeah  
528.48 -> so for representing it as a primary key we  will be having the ID annotation okay ID  
533.22 -> just hit enter and I will also add a column name  okay so we can specify the column name manually  
538.62 -> as well by using the column annotation like if  you want the default ID to be the column name  
543.24 -> you can also have that I will just have this so  just open bracket have name and I will just give  
549.12 -> it as ID that's it and for this ID to be Auto  incremented or Auto generated value we can just  
556.38 -> have the generated value function okay yeah  so these are some of the standard stuff that  
561.48 -> everyone uses for a particular unique ID in the  column so next one is going to be the mark and  
566.58 -> name so it's going to be private is going to be of  type int and it's Mark yeah and same thing column  
577.68 -> is going to be the lone annotation  column and name is going to be  
584.64 -> students Mark like that and the final one is  going to be the name private this is of type  
594.24 -> string with capital s and I'll put name and it  will also have the column annotation okay column
602.4 -> I will have the name equal to I'll just go  with the standard name that's it yeah no worries  
609 -> this this is now fine so these are some of the  columns that we'll be having in our table so  
613.98 -> after doing all this we need to also add some  main annotations to our student class okay so  
618.96 -> the first annotation is the entity so entity is  like we will be referencing spring boot that this  
625.14 -> particular class corresponds to that particular  table present in MySQL DB okay so that's what the  
630.36 -> entity annotation does it's important to have that  and next we'll be using the data annotation this  
635.04 -> is present inside Lombok so whenever we are  creating a class we need to have all those getters  
640.08 -> setters as well as so many things are there but by  using this data annotation this will automatically  
645.24 -> create all the Getters and Setters for each and  every data member for our class so always better  
650.46 -> to use lombok and this data annotation so after  this we will be also having the table okay so  
656.04 -> this table annotation exactly similar to column  annotation by through which we'll be referencing  
660.3 -> our table name so this particular name that  we will be specifying over here is going to  
665.52 -> be the table name in our MySQL DB so I will  just have a name it as I will go with student  
674.82 -> underscore DB something like that yeah so this  is now fine so after this we can also add the  
681.48 -> constructors so it's going to be capital  N I guess yeah then no org Constructor so  
688.8 -> so same thing we also need to create a  Constructor and initialize the values so  
692.34 -> we need to have an empty Constructor as well as  a Constructor the data members value so these  
696.36 -> are some of the standard stuff so by using this  annotations we can like bypass those things as  
701.4 -> they are automatically done with the help  of these annotations so it's going to be all  
706.62 -> args Constructor okay yeah some of the  standard things so now we are good with our  
711.9 -> entity class so after this we will be creating  a repository interface so it's not a class it is  
717.36 -> an interface so which is also used to basically  like reference to this particular entity so it  
721.92 -> is like this okay every entity of a table in  Spring boot will have a repository of its own  
726.3 -> through which we will be able to execute queries  and other stuff okay so just imagine it as that  
730.92 -> way so just come to your repository folder now  we are done with our student.java I will just  
735.12 -> close it okay just close this as well yeah and  we'll just come to repository right click new  
742.38 -> it's going to be of java class but it's going to  be of type interface okay I will just name it as
750.6 -> student repo okay it's also always good  to have in camel case just hit enter and  
756.84 -> if you want to name this as student entity you  can also do that okay just name it as student  
761.28 -> entity it's your Total Choice it will be  more like readable and understandable if  
765.6 -> you have that way in case of like you're having  more number of files since I'm having only one  
769.44 -> file I will just name it as student okay  so that is good so now let me come to my  
773.22 -> repository and here you can see right this  is an interface okay this is not a class
778.08 -> so student repo , first thing we need to have extends okay this is a keyword extends and after this  we need to add the jpa repository which is like an  
787.08 -> inbuilt class of spring boot so it's going to be  jpa capital J okay capital J we will be having the  
792.72 -> jpa repository over here just hit enter so through  this way we'll be able to perform all the CRUD  
797.34 -> operations to our database or entity so just  expand this okay yeah we'll be having this greater  
803.1 -> than less than symbol and within that we need to  specify our class name of our entity so my class  
808.68 -> name over here is student okay so you have to  specify that first over here so it's going to be  
812.58 -> student you will be having here yeah student here  it is okay you want to specify the class name and  
818.82 -> this will get automatically imported and a comma  and here we need to specify the data type of the  
824.82 -> primary key of our student class so student class  is over here and the data type of our primary key  
831.42 -> is of type integer okay so you need to specify  that get a type of the primary key so it's going  
836.64 -> to be obviously integers in 99 of the cases okay 99 percentage of cases so just specify the  
842.52 -> data type of the primary key which is integer okay so  that's it now we are done with our repository  
847.68 -> and entity is also done repository is done so  next thing we have only service and controller  
853.26 -> so what service basically does is that it allows  us to perform the post save put fetch all the  
860.16 -> operations okay so just go to service right click  it and new and this time it's going to be a plain  
866.22 -> Java class not any interface or something so  I will just type it as student service always  
872.82 -> good to use camel case Okay use camel case  everywhere okay and I will just now hit enter
880.02 -> so we'll be getting the service I will close the  repository and in the service we will be able to  
884.7 -> access the entity through the repository variable  okay so the repository object we can't access a  
890.7 -> entity directly okay so only with the help of  the repo we will be able to access the objects  
896.16 -> or data members or the functions that are present  inside our entity student I hope that made sense  
900.84 -> so in the service the first important thing is we  need to annotate the service okay so it's going  
905.46 -> to be at service annotation to reference it as a  service class so after this we will be creating  
911.1 -> our reference variable or object of our repository  so as I told you earlier we would be only able to  
916.98 -> access the student class details through the  repository object okay with this help of the  
922.02 -> object of student repo so I will create that okay  so it's going to be private the name is student
930.06 -> repo yeah so I will name it as the small s okay  student repo yeah this is a naming convention okay  
937.62 -> whenever you are creating a variable the first  thing should be the class name itself and after  
942.06 -> that the variable should be like the smaller  letter of that particular class name itself  
945.9 -> so it's like a common naming convention used so  we will be able to access only the values present 
950.22 -> in our main student class with the help of this  variable or object okay also you have to annotate  
955.62 -> with this Auto wired okay yeah so this is used for  basically like dependency injection or referencing  
962.7 -> our repository variable over here so you need to use this Auto wired otherwise  
967.02 -> you'll be getting an error okay so now we are done  so next thing we will be creating a function for  
972.9 -> saving or posting the data okay because that  is our main name in this video okay we have  
976.98 -> to post and save data in the database so for that  we'll be creating a function so it's going to be  
981.48 -> public you need to create it as public okay because  we will be using this function in our controller  
986.52 -> okay controller will be having a Java class and  we will be using this particular function over  
991.02 -> there so it's always good to have our function  as public and the return type of this particular  
996.6 -> function is going to be of student okay student  means this particular class okay this main entity  
1001.46 -> class so it's going to be of type student and next  is the name of our function I will have it as save  
1010.52 -> details you can name it as anything you want  and the function is going to have only one  
1016.28 -> parameter that parameter is going to be a object  of the class student so what I mean by object is  
1021.5 -> that it is going to be like this things ID Mark  and name so these are the data members and this  
1026.42 -> particular parameter will have all these values  as an object inside it so it's going to be student  
1034.46 -> yeah student I will go with the  same naming conversion like with a  
1038 -> small s after that Student student so after this
1041.31 -> we will be returning it okay since we have used student over there , we need to return it , return we will be using the repo name
1047.378 -> as I told you for accessing the values or  saving anything we'll be using the repo  
1051.14 -> object or variable so it's going to be return  student repo Dot and here we'll be having so many  
1058.4 -> functions okay so in that we'll be using the  save so this basically saves our data in our  
1063.02 -> table as simple as that save and inside that  we're going to pass our object okay student  
1070.04 -> student this variable okay this variable over  here so this student will have all the details  
1074.9 -> like ID Mark and name in object form and we are  just saving it in the table simple so now we are  
1081.02 -> done with our entity and the final thing that  is left is our controller so the main purpose  
1085.58 -> of controller is defining the path and the  operation so here you can see right let me  
1090.08 -> go to my Postman so here you can see right we  will be having so many operations post put  
1094.7 -> Fetch and delete there are so many operations  and we'll be also having this particular path  
1099.14 -> or the root Okay add student for post we will be  having for put we will be having put delete will  
1104.36 -> be having slash delete so we will specify  all these details in the controller so just  
1109.4 -> right click controller new you will be having that  Java class select it I will just name it as student
1117.86 -> controller like that class okay everything  is class except repository okay and we'll be  
1123.74 -> getting the student controller over here and  we will Begin by annotating the controller  
1128.66 -> class with rest controller okay so this is  to specify that this is a controller class  
1133.88 -> so after that we will be creating a service  variable okay so here in service again service  
1140.48 -> we had an object of student repo exactly  similar to that in our controller we will be  
1146.12 -> having an object of the service class okay so  service class name is student service okay so  
1151.28 -> I'll just go to my controller so it's going to  be private student I think it's Capital s yeah  
1160.04 -> student will be having the student service  okay so we'll be creating a variable of our  
1164.48 -> service okay student service I hope that made  sense this one student service yeah and you  
1170.06 -> can name it after that it's going to be the  same thing the small s student service yeah  
1174.08 -> and we will also annotate it with auto  wired exact same thing for referencing it  
1179.84 -> yeah so we are done and after this we'll be  creating another function so here the main  
1184.94 -> root or the path for our post operation will be  specified so as I told you write this particular  
1189.74 -> path needs a function okay every path will have a  function to its own so just come here the function  
1195.32 -> as I told you it's going to be public okay in  most of the cases public and it's going to be  
1199.64 -> of the type student okay student as usual the  main entity and it's going to be I will have it  
1205.4 -> as add details or post okay post details okay post  details that's going to be the name and after that  
1213.02 -> this will take an argument okay so this  is this argument is going to be of type  
1217.94 -> student okay same student okay same student  everywhere student and the smallest student okay  
1226.1 -> but we need to also add a particular annotation  which is at request body okay so the reason is  
1233.96 -> because we will be sending data over here okay we  will be sending data from our Postman so where is  
1239.3 -> that it's raw yeah so we'll be setting a Json  data from our Postman and with the help of this  
1245.06 -> request body that particular data will be faced  by the student object okay so once we are hitting  
1250.82 -> that particular path this particular data will  be fixed by this particular function okay so I  
1255.8 -> will like add the path and it will make more  sense after that so in this in this function  
1260.24 -> we'll be having at post mapping so to reference  that this particular function will handle the  
1267.5 -> post operation in this class or controller so  we need that post mapping so in general we'll  
1272.54 -> be using post mapping for post operations so  this will take the path so I will go with ADD  
1279.02 -> student okay so now I hope it will make more sense  so this add student will come over here okay will  
1286.34 -> come over here after this port number slash that  particular Astron will be coming here so when I  
1291.86 -> send the data as a request this particular data  will be then caught by this particular request  
1297.62 -> body of student okay then this student will have  basically these details so I hope now it will be  
1303.5 -> clear for you so inter is this function exact same  thing we have to return it okay so it's going to  
1308.06 -> be written and we'll be using this service student  service so it's going to be student service  
1315.92 -> Dot and with the help of the student service  variable we will be accessing this particular  
1321.5 -> function inside of a student service you know  this function right save details we created  
1325.64 -> earlier so with the help of this variable that we  have created in our controller we will be able to  
1331.46 -> access this particular save details function okay  so it should be Dot save details within that will  
1338 -> be passed the student variable okay so that's the  code so now let me explain you how this works in  
1343.4 -> a simple term okay so I'll just close these things  only the main thing is going to be controller and  
1347.12 -> the service okay let's start the standard stuff  so I'll go to my Postman so I'll just explain it  
1352.28 -> in a demo way after that I will run and show you  so we'll be adding the localhost the student the  
1356.36 -> path after that we will like have a Json data and  whenever we hit send this particular path slash a  
1363.2 -> student will be hit okay so after hitting that  it will come over here this path will be like  
1368.24 -> it will check whether we are having this add  student path so this particular path that we  
1372.14 -> have sent in Postman matches with this path so it  will come over here and we are having the request  
1377.18 -> body annotation with the student object okay so  this data that we have sent over here will be now  
1382.7 -> present inside the student variable this variable  with the help of this request body annotation so  
1387.92 -> after this this student variable will be having  these values it will come over here here you can  
1392.66 -> see it's student service dot save details student  it so basically we are passing all these data  
1400.1 -> to the save details function which is present  inside our service okay so now I will go to my  
1406.16 -> service service this particular save details  function so I'll go here the saved relates  
1411.26 -> function is also having a parameter of student  okay so now this student will be referenced to  
1416.66 -> as the student over here okay it's like function  calls basically so what happens is that this  
1421.52 -> data will num come to the function save details  present inside our service from the controller  
1427.7 -> so it's like that it it's from the postman data  to our controller function from the controller  
1435.32 -> function it goes to our service function and in  the service function we are just saving it with  
1440.96 -> the help of dot save through our repo like  the repository variable that we have created  
1444.92 -> earlier so because of this dot save it gets then  saved in our MySQL workbench or database table  
1452.06 -> so this is the entire workflow okay so this is  how it will work so now let me just run and show  
1458.36 -> you this program okay just come to this spring  Pro application that is the main file if you  
1462.92 -> aren't having this run thing just right click  it and you just click on run project and if you  
1468.56 -> aren't having this edit configurations I will just  open it so yeah this is my rate configuration here  
1475.82 -> it specifies a Java the main thing and here it  is specifically the working directory so these  
1480.44 -> are the standard stuff and I'll just now close  it and now in my database okay so this is my  
1486.86 -> um database I will go to tables I'm having only  my table so I'm not having the table any table  
1492.74 -> named a student so here in entity right you have  specified the table name to be as student DB so  
1498.74 -> if this program runs successfully we have to  get the student DB automatically created over  
1502.88 -> here and after that we will be sending some data  from our Postman so I will just now run the code I  
1508.76 -> hope it works a lot of effort into it and I don't  want to get any errors right now so I will run it
1516.86 -> so after some time you will be getting some  logs like this and if you get this final thing  
1521.12 -> as spring application started so which means  that there aren't any errors and here you can  
1525.92 -> see right we'll be getting some SQL commands  over here as well so here you can see right  
1529.64 -> uh create table student DB so if I just now  go to my bench and if I just now refresh it  
1539.06 -> so here you can see that I will  be having the student DB over  
1541.58 -> here so if I just now go to my select  asterisk from I will just run student
1550.22 -> and I will go with underscore DB and if I just  now run it we will be having three columns which  
1557.36 -> is going to be of type ID St Mark and name  so here you can see right instead yeah this  
1563.96 -> particular name that I've specified over here will  be directly coming to the column name as simple  
1569.18 -> as that and another important thing you need to  note here is that the port number on which your  
1573.44 -> stream boot application is running so if you just  now come here so here you can see that our spring  
1578.3 -> boot has now started around port 8080 so this  is like the default Port so now let's see what  
1584.24 -> happens when we some post data from our Postman  because that's our aim over here we need to save  
1588.86 -> data currently our table is empty so for that  this is the port okay so just copy this eight  
1594.62 -> zero eight zero so this is like a default Port  so I will just come to my Postman and here we  
1601.58 -> need to change this port to eight zero eight zero  okay important thing I will show you the important  
1605.42 -> thing what we need to learn so it's going to be  localhost colon 8080 and here we are going to do  
1611 -> Post data so just click here the operation and  change it to post really important thing many  
1617.06 -> people won't do that and after that you know to  come to body and it will be none at default I  
1621.98 -> guess body none you need to go to law after that  and you have to have like this okay the format I'm  
1628.88 -> inserting here only name and Mark values because  my ID is auto generated as I told you right my ID  
1634.76 -> value is auto generated because of this generated  value annotation so that's the reason why I'm not  
1639.8 -> referencing ID over here I'm having only name and  what values sent as a request body so you need  
1645.92 -> to have raw have name within double quotes hello  within double quotes mark key within double quotes  
1650.6 -> and since 100 is of type int no need double quotes  to that okay be careful there as well after that  
1656.06 -> here also important thing you have to have this  type as Json okay you have to change this to Json  
1661.1 -> I think it will be text by default if you put text  it will it will give an error so I have it as Json  
1667.52 -> another important thing and I think yeah that's it  these are the important things operation I need to  
1672.86 -> change the path as well so the path that we have  specified in our controller that is controller  
1678.68 -> yeah student controller this particular path  should come over here you need to be careful  
1683.18 -> with the KSS as well so I'll just change it  to some meaningful name okay I will just put  
1688.76 -> not meaningful hello hi something like that like  this and I will go with thousand as the mark some  
1694.46 -> random thing if I just now send it so it's sending  requests yeah so we have got the result over here  
1704.12 -> so we have got the result as a response because we  are like returning it okay here you can see that  
1708.74 -> we have returned that particular thing and we have  got this thing and if I just now go to my MySQL  
1717.14 -> table and run it so here you can see right I've  got the value 1 which is auto generated I am not  
1721.82 -> sending ID over here and the name and Mark are  coming and in case what if you want some other  
1726.86 -> response okay you don't want the Json to be  appearing over here you can just change it  
1730.82 -> by going to your controller you can just remove  this return you need to just change this as string  
1737.78 -> because we'll be returning a string text okay and  I will come over here I will just return something  
1743.36 -> as posted so this will work fine if you don't have  any errors okay I'm just doing it since I'm not  
1751.22 -> having any errors but in case of like company or  a much more standard way we should never do this  
1755.66 -> one okay never do never directly return a string  or variable okay I'm just showing it for a demo  
1759.56 -> purpose so like just to know how this basically  works why we are adding the class name over here  
1764.96 -> so that's the reason why I'm doing this so I'll  just now re-run it for re-running it just click  
1768.92 -> this button okay so it will restart again yeah  so here you can see that it's restarting yeah  
1773.3 -> so my application has now restarted so I will  go to my Postman again and this time we won't  
1777.74 -> be getting the Json over here rather than that  we will be getting this particular posted text  
1782.12 -> appearing in our response area so I will just  now move this and I will just change it to
1791.42 -> fold or something I'll just put word some random  
1793.76 -> name and I will give the mark As  triple one and if I send it now
1801.74 -> so here you can see that I'm getting that  particular text over here so that's the  
1805.04 -> purpose it's not necessary that you don't have  that and here you can see that this is how the  
1808.46 -> insert operation Works insert into student  the values like that yeah so that's the SQL  
1814.04 -> like the query for what the operation that is  being currently performed the post operation  
1818.78 -> so if I just now go to my MySQL  DB and run this command again
1825.08 -> so we'll be having the value the triple one  and the word that I sent over here so you  
1829.58 -> can have a string over here or you can just  leave the normal way how it was earlier the  
1834.14 -> normal way is fine I guess so this is how you  post data in mySQL database by using spring  
1839.36 -> Boot and Postman so I'll be also doing many  other posts put get deleted minimum maximum  
1844.1 -> Auto increment everything so I have also  done node.js react.js as well as current  
1849.68 -> operations in MySQL as well as mongodb  by using node.js so you can also check  
1853.76 -> them it's in the playlist of my channel as  well I have also run tutorials in C C plus  
1857.84 -> plus Java python so do check other videos of  my channel and playlist thanks for watching

Source: https://www.youtube.com/watch?v=fgVoVt2EGpM