gdata.io.handleScriptLoaded({"version":"1.0","encoding":"UTF-8","feed":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$openSearch":"http://a9.com/-/spec/opensearchrss/1.0/","xmlns$gd":"http://schemas.google.com/g/2005","xmlns$georss":"http://www.georss.org/georss","xmlns$thr":"http://purl.org/syndication/thread/1.0","xmlns$blogger":"http://schemas.google.com/blogger/2008","id":{"$t":"tag:blogger.com,1999:blog-913600556879440043"},"updated":{"$t":"2024-01-01T15:38:08.302+05:30"},"category":[{"term":"Data Structures"},{"term":"Vedic Mathematics"},{"term":"My Vlogs"},{"term":"Website Designing"},{"term":"Guest Blogging"},{"term":"Youtube"},{"term":"PPL"},{"term":"Android"},{"term":"Android App Development"},{"term":"High Performance Computing"},{"term":"Socket Programming"},{"term":"Java"},{"term":"Cloud Computing"},{"term":"Unboxing \u0026 Review"},{"term":"Database"},{"term":"OpenMPI"},{"term":"OPENCL"},{"term":"CUDA"},{"term":"LEX \u0026 YACC"},{"term":"Vocabulary"},{"term":"Compiler"},{"term":"Blogging Tips"},{"term":"Networking"},{"term":"Linux"},{"term":"Nanded City Pune"},{"term":"Parallel Computing"},{"term":"SDL"},{"term":"Fedora"},{"term":"Udemy Courses"},{"term":"Dia Software"},{"term":"MPI"},{"term":"Multithreading"},{"term":"Computer Networks"},{"term":"Abbreviations in Computer Science"},{"term":"Salesforce"},{"term":"Lisp"},{"term":"YouTube Tips"},{"term":"MS Excel Formulas \u0026 Functions"},{"term":"C Plus Plus Programming"},{"term":"GATE"},{"term":"Mysql"},{"term":"Google Forms"},{"term":"Wine"},{"term":"Swing"},{"term":"Mathematics"},{"term":"SQL"},{"term":"Amazon Links Summary"},{"term":"Thread Pool"},{"term":"General"},{"term":"Amazon Affiliate Program"},{"term":"How To Write Blog"},{"term":"C Programming"},{"term":"Applet"},{"term":"Selenium Automation Testing"},{"term":"Skill Development Lab"},{"term":"OPENMP"},{"term":"Python"},{"term":"Ubuntu"}],"title":{"type":"text","$t":"Computer Revolution (www.comrevo.com)"},"subtitle":{"type":"html","$t":""},"link":[{"rel":"http://schemas.google.com/g/2005#feed","type":"application/atom+xml","href":"https://www.blogger.com/feeds/913600556879440043/posts/default/-/SQL?alt\u003djson-in-script\u0026max-results\u003d6"},{"rel":"self","type":"application/atom+xml","href":"https://www.blogger.com/feeds/913600556879440043/posts/default/-/SQL?alt\u003djson-in-script\u0026max-results\u003d6"},{"rel":"alternate","type":"text/html","href":"http://www.comrevo.com/search/label/SQL"},{"rel":"hub","href":"http://pubsubhubbub.appspot.com/"}],"author":[{"name":{"$t":"Parag Jambhulkar"},"uri":{"$t":"https://www.blogger.com/profile/13991750622483538113"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"35","height":"35","src":"//www.blogger.com/img/blogger_logo_round_35.png"}}],"generator":{"version":"7.00","uri":"https://www.blogger.com","$t":"Blogger"},"openSearch$totalResults":{"$t":"4"},"openSearch$startIndex":{"$t":"1"},"openSearch$itemsPerPage":{"$t":"6"},"entry":[{"id":{"$t":"tag:blogger.com,1999:blog-913600556879440043.post-6559038143277845616"},"published":{"$t":"2019-07-25T12:08:00.002+05:30"},"updated":{"$t":"2020-09-25T10:52:43.697+05:30"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Database"},{"scheme":"http://www.blogger.com/atom/ns#","term":"SQL"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Skill Development Lab"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Mysql"}],"title":{"type":"text","$t":"How to create procedure in MySQL database?"},"content":{"type":"html","$t":"\u003cdiv dir\u003d\"ltr\" style\u003d\"text-align: left;\" trbidi\u003d\"on\"\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; In this post, we will see how to create procedure in MySQL database\u003c/span\u003e.\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003eWhat is the need of procedure?\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e1. By creating procedure, we can run multiple SQL queries in a single call.\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e2. Another advantage is that procedure is stored and can be called at any time. No need to write same SQL queries again and again.\u0026nbsp;\u003c/span\u003e\u003c/div\u003e\u003cdiv dir\u003d\"ltr\" style\u003d\"text-align: left;\" trbidi\u003d\"on\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\u003c/div\u003e\u003cdiv dir\u003d\"ltr\" style\u003d\"text-align: left;\" trbidi\u003d\"on\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003eFor Demonstration, watch following video:\u003c/span\u003e\u003c/div\u003e\u003cdiv dir\u003d\"ltr\" style\u003d\"text-align: left;\" trbidi\u003d\"on\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\n  \n  \u003ciframe width\u003d\"640\" height\u003d\"360\" src\u003d\"https://www.youtube.com/embed/02clWrruoKE\" frameborder\u003d\"0\" allow\u003d\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen\u003e\u003c/iframe\u003e\n  \n  \n  \u003c/span\u003e\u003c/div\u003e\u003cdiv dir\u003d\"ltr\" style\u003d\"text-align: left;\" trbidi\u003d\"on\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cb\u003eWatch on YouTube:\u0026nbsp;\u003ca href\u003d\"https://www.youtube.com/watch?v\u003d02clWrruoKE\" target\u003d\"_blank\"\u003ehttps://www.youtube.com/watch?v\u003d02clWrruoKE\u003c/a\u003e\u003c/b\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; Check following example:\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003ca name\u003d'more'\u003e\u003c/a\u003e\u003cbr /\u003e\n\u003cb style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003eProcedure in MySQL:\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003ctable border\u003d\"1\"\u003e\u003ctbody\u003e\n\u003ctr\u003e\u003ctd\u003e\u003cspan style\u003d\"font-size: large;\"\u003emysql\u0026gt; delimiter //\u003cbr /\u003emysql\u0026gt; create procedure sample()\u003cbr /\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp; -\u0026gt; begin\u003cbr /\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp; -\u0026gt; insert into student values(3303,'TE','GCOE','Amravati');\u003cbr /\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp; -\u0026gt; update student set city\u003d'Aurangabad' where college\u003d'GCOE';\u003cbr /\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp; -\u0026gt; select * from student;\u003cbr /\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp; -\u0026gt; end//\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003emysql\u0026gt; delimiter ; \u003c/span\u003e\u003c/td\u003e\u003c/tr\u003e\n\u003c/tbody\u003e\u003c/table\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u003c/span\u003e\u003cbr /\u003e\n\u003cdiv style\u003d\"margin: 0px;\"\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cb\u003eOutput:\u003c/b\u003e\u003c/span\u003e\u003c/span\u003e\u003c/span\u003e\u003c/div\u003e\n\u003ctable border\u003d\"1\"\u003e\u003ctbody\u003e\n\u003ctr\u003e\u003ctd\u003e\u003cspan style\u003d\"font-size: large;\"\u003emysql\u0026gt; call sample();\u003cbr /\u003e+--------+-------+---------+------------+\u003cbr /\u003e| rollno | class | college | city\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; |\u003cbr /\u003e+--------+-------+---------+------------+\u003cbr /\u003e|\u0026nbsp;\u0026nbsp; 1221 | SE\u0026nbsp;\u0026nbsp;\u0026nbsp; | PICT\u0026nbsp;\u0026nbsp;\u0026nbsp; | Pune\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; |\u003cbr /\u003e|\u0026nbsp;\u0026nbsp; 3221 | TE\u0026nbsp;\u0026nbsp;\u0026nbsp; | VJTI\u0026nbsp;\u0026nbsp;\u0026nbsp; | Mumbai\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; |\u003cbr /\u003e|\u0026nbsp;\u0026nbsp; 1201 | se\u0026nbsp;\u0026nbsp;\u0026nbsp; | vjti\u0026nbsp;\u0026nbsp;\u0026nbsp; | mumbai\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; |\u003cbr /\u003e|\u0026nbsp;\u0026nbsp; 3201 | te\u0026nbsp;\u0026nbsp;\u0026nbsp; | coep\u0026nbsp;\u0026nbsp;\u0026nbsp; | Pune\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; |\u003cbr /\u003e|\u0026nbsp;\u0026nbsp; 4201 | be\u0026nbsp;\u0026nbsp;\u0026nbsp; | wce\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; | Sangli\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; |\u003cbr /\u003e|\u0026nbsp;\u0026nbsp; 2301 | SE\u0026nbsp;\u0026nbsp;\u0026nbsp; | COEP\u0026nbsp;\u0026nbsp;\u0026nbsp; | Pune\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; |\u003cbr /\u003e|\u0026nbsp;\u0026nbsp; 3301 | TE\u0026nbsp;\u0026nbsp;\u0026nbsp; | SGGS\u0026nbsp;\u0026nbsp;\u0026nbsp; | Nanded\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; |\u003cbr /\u003e|\u0026nbsp;\u0026nbsp; 3303 | TE\u0026nbsp;\u0026nbsp;\u0026nbsp; | GCOE\u0026nbsp;\u0026nbsp;\u0026nbsp; | Aurangabad |\u003cbr /\u003e+--------+-------+---------+------------+\u003cbr /\u003e8 rows in set (0.17 sec)\u003cbr /\u003e\u003cbr /\u003eQuery OK, 0 rows affected (0.17 sec)\u003c/span\u003e\u003c/td\u003e\u003c/tr\u003e\n\u003c/tbody\u003e\u003c/table\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003eExplanation\u003c/span\u003e\u003c/b\u003e\u003c/u\u003e\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e:\u0026nbsp;\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003cb\u003edelimiter\u003c/b\u003e command is used to change the end of MySQL Query.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ee.g. Generally end of SQL query is \u003cb\u003e;\u003c/b\u003e . Now, if we want to change it to \u003cb\u003e//\u003c/b\u003e. Then execute \u003cb\u003edelimiter //\u003c/b\u003e. If we want to make end of each sql query as \u003cb\u003e$$\u003c/b\u003e, then execute \u003cb\u003edelimiter $$\u003c/b\u003e.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; In above example, we have to add multiple SQL queries in procedure \u003cb\u003esample()\u003c/b\u003e, hence we have changed the end of SQL query as \u003cb\u003e//\u003c/b\u003e by executing \u003cb\u003edelimiter //\u003c/b\u003e. After defining procedure sample, again we have reset the end of SQL query as \u003cb\u003e;\u003c/b\u003e by executing \u003cb\u003edelimiter ;\u003c/b\u003e .\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax for creating procedure in MySQL is as follows:\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ecreate procedure procedure_name\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ebegin\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; SQL Queries;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eend\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax for calling procedure is as follows:\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ecall procedure_name();\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax for displaying all procedures:\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eshow procedure status;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax for deleting any procedure:\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003edrop procedure procedure_name;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax for getting all options for show command:\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ehelp show; \u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003e\u003cb\u003eFind how to use parameters IN, OUT, INOUT in MySQL procedure in next \u003c/b\u003e\u003cb\u003epost\u003c/b\u003e\u003c/u\u003e\u0026nbsp; \u003ca href\u003d\"https://www.comrevo.com/2019/07/mysql-stored-procedure-parameters-in-out-inout.html\" target\u003d\"_blank\"\u003ehttps://www.comrevo.com/2019/07/mysql-stored-procedure-parameters-in-out-inout.html\u003c/a\u003e. \u003c/span\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u003c/span\u003e\u003c/div\u003e\n"},"link":[{"rel":"replies","type":"application/atom+xml","href":"https://www.comrevo.com/feeds/6559038143277845616/comments/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"https://www.comrevo.com/2019/07/how-to-create-procedure-in-mysql-database.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"https://www.blogger.com/feeds/913600556879440043/posts/default/6559038143277845616"},{"rel":"self","type":"application/atom+xml","href":"https://www.blogger.com/feeds/913600556879440043/posts/default/6559038143277845616"},{"rel":"alternate","type":"text/html","href":"https://www.comrevo.com/2019/07/how-to-create-procedure-in-mysql-database.html","title":"How to create procedure in MySQL database?"}],"author":[{"name":{"$t":"Parag Jambhulkar"},"uri":{"$t":"https://www.blogger.com/profile/13991750622483538113"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"35","height":"35","src":"//www.blogger.com/img/blogger_logo_round_35.png"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https://i.ytimg.com/vi/02clWrruoKE/default.jpg","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-913600556879440043.post-7747742382264790720"},"published":{"$t":"2019-07-16T14:11:00.000+05:30"},"updated":{"$t":"2019-07-16T14:18:05.815+05:30"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Database"},{"scheme":"http://www.blogger.com/atom/ns#","term":"SQL"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Mysql"}],"title":{"type":"text","$t":"Solution for Mysql error: access denied for user 'root'@'localhost' "},"content":{"type":"html","$t":"\u003cdiv dir\u003d\"ltr\" style\u003d\"text-align: left;\" trbidi\u003d\"on\"\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; In this post, we will see solution for the mysql error \u003cb\u003eaccess denied for user 'root'@'localhost'\u003c/b\u003e\u003c/span\u003e.\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003ca name\u003d'more'\u003e\u003c/a\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; After installing Mysql in linux (In Ubuntu, by running command sudo apt-get install mysql-server), when we open mysql by running following command\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003emysql -u root -p\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; We may get error \u003cb\u003emysql access denied for user 'root'@'localhost'\u003c/b\u003e.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; There are many solutions available on net. Best solution I found is as follows:\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eRun following command in terminal:\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003esudo mysql\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\u003c/b\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cb\u003eALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';\u003c/b\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; It works for me. Hope it will helpful for you. It changes mysql root password to \u003cb\u003eroot\u003c/b\u003e.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eThanks a lot.\u003c/span\u003e\u003c/div\u003e\n"},"link":[{"rel":"replies","type":"application/atom+xml","href":"https://www.comrevo.com/feeds/7747742382264790720/comments/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"https://www.comrevo.com/2019/07/mysql-access-denied-for-user-root-at-localhost.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"https://www.blogger.com/feeds/913600556879440043/posts/default/7747742382264790720"},{"rel":"self","type":"application/atom+xml","href":"https://www.blogger.com/feeds/913600556879440043/posts/default/7747742382264790720"},{"rel":"alternate","type":"text/html","href":"https://www.comrevo.com/2019/07/mysql-access-denied-for-user-root-at-localhost.html","title":"Solution for Mysql error: access denied for user 'root'@'localhost' "}],"author":[{"name":{"$t":"Parag Jambhulkar"},"uri":{"$t":"https://www.blogger.com/profile/13991750622483538113"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"35","height":"35","src":"//www.blogger.com/img/blogger_logo_round_35.png"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-913600556879440043.post-8428938104244973470"},"published":{"$t":"2017-01-03T16:01:00.004+05:30"},"updated":{"$t":"2017-08-31T09:25:59.690+05:30"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"SQL"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Java"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Mysql"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Website Designing"}],"title":{"type":"text","$t":"How to insert and retrieve image from mysql database in jsp"},"content":{"type":"html","$t":"\u003cdiv dir\u003d\"ltr\" style\u003d\"text-align: left;\" trbidi\u003d\"on\"\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; In this post, we will see how to insert and retrieve image from mysql database in jsp.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; Here, frontend and backend programs are in JSP while database used is Mysql. Database name is \"test\", Database user name is also \"test\" and password is \"123\". Table name in which I have inserted image here, is \"biodata\". Table's configuration is shown in following screenshot:\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003c/span\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cbr /\u003e\n\u003ca name\u003d'more'\u003e\u003c/a\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003c/span\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cbr /\u003e\n\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\n\u003c/div\u003e\n\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\n\u003ca href\u003d\"https://4.bp.blogspot.com/-T7JvskHckKU/WGt6N7ggGqI/AAAAAAAADMk/YGE-0HnuEwkHXffVkANhQM8YR_sROVK1ACLcB/s1600/biodata%2Bimage.jpeg\" imageanchor\u003d\"1\" style\u003d\"margin-left: 1em; margin-right: 1em;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cimg border\u003d\"0\" height\u003d\"201\" src\u003d\"https://4.bp.blogspot.com/-T7JvskHckKU/WGt6N7ggGqI/AAAAAAAADMk/YGE-0HnuEwkHXffVkANhQM8YR_sROVK1ACLcB/s640/biodata%2Bimage.jpeg\" width\u003d\"640\" /\u003e\u003c/span\u003e\u003c/a\u003e\u003c/div\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cb\u003euploadimage.jsp\u003c/b\u003e\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cdiv style\u003d\"background: lightgreen;\"\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;%@ page language\u003d\"java\" contentType\u003d\"text/html; charset\u003dISO-8859-1\"\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; pageEncoding\u003d\"ISO-8859-1\"%\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \"http://www.w3.org/TR/html4/loose.dtd\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;html\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;head\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;meta http-equiv\u003d\"Content-Type\" content\u003d\"text/html; charset\u003dISO-8859-1\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;title\u0026gt;Image Upload to MySQL Database Demo\u0026lt;/title\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/head\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;body\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp;\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;h1\u0026gt;Image Upload to MySQL Database Demo\u0026lt;/h1\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;form method\u003d\"post\" action\u003d\"uploadimagebackend.jsp\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;table border\u003d\"0\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td\u0026gt;First Name: \u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td\u0026gt;\u0026lt;input type\u003d\"text\" name\u003d\"firstname\" size\u003d\"50\"/\u0026gt;\u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td\u0026gt;Last Name: \u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td\u0026gt;\u0026lt;input type\u003d\"text\" name\u003d\"lastname\" size\u003d\"50\"/\u0026gt;\u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td\u0026gt;Path of Image on Disk: \u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td\u0026gt;\u0026lt;input type\u003d\"text\" name\u003d\"photo\" size\u003d\"50\"/\u0026gt;\u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td colspan\u003d\"2\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;input type\u003d\"submit\" value\u003d\"Submit\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/tr\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/table\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/form\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp;\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/body\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003c/span\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/html\u0026gt;\u003c/span\u003e\u003c/div\u003e\n\u003cdiv\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cb\u003eOutput:\u003c/b\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\n\u003ca href\u003d\"https://1.bp.blogspot.com/-oM57mNe1qP4/WGt8IcavGjI/AAAAAAAADMw/8z7R88w79b0CUWEKIxv5rMtPQkJX1A6AgCLcB/s1600/uploadimage.jpeg\" imageanchor\u003d\"1\" style\u003d\"margin-left: 1em; margin-right: 1em;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cimg border\u003d\"0\" src\u003d\"https://1.bp.blogspot.com/-oM57mNe1qP4/WGt8IcavGjI/AAAAAAAADMw/8z7R88w79b0CUWEKIxv5rMtPQkJX1A6AgCLcB/s1600/uploadimage.jpeg\" /\u003e\u003c/span\u003e\u003c/a\u003e\u003c/div\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cb\u003e\u003cbr /\u003e\u003c/b\u003e\u003c/span\u003e\n\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cb\u003e\u003cbr /\u003e\u003c/b\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cb\u003euploadimagebackend.jsp\u003c/b\u003e\u003c/span\u003e\u003c/span\u003e\u003c/div\u003e\n\u003cdiv style\u003d\"background: lightgreen;\"\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u0026lt;%@ page import\u003d\"java.io.*,java.util.*,java.sql.*\"%\u0026gt;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;%@ page import\u003d\"javax.servlet.http.*,javax.servlet.*\" %\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;%@ taglib uri\u003d\"http://java.sun.com/jsp/jstl/core\" prefix\u003d\"c\"%\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;%@ taglib uri\u003d\"http://java.sun.com/jsp/jstl/sql\" prefix\u003d\"sql\"%\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;html\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;head\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/head\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;body\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;div style\u003d\"background-color:SlateGray\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;h1\u0026gt;Image Upload to MySQL Database Demo\u0026lt;/h1\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/div\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u0026lt;%\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eString firstname \u003d request.getParameter(\"firstname\");\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eString lastname \u003d request.getParameter(\"lastname\");\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eString myphoto \u003d request.getParameter(\"photo\");\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eConnection con\u003dnull;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eResultSet rs\u003dnull;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003ePreparedStatement psmt\u003dnull;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eFileInputStream fis;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eString url\u003d\"jdbc:mysql://localhost:3306/test\";\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003etry{\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eClass.forName(\"com.mysql.jdbc.Driver\").newInstance();\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003econ\u003dDriverManager.getConnection(url,\"test\",\"123\");\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eFile image\u003dnew File(myphoto);\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003epsmt\u003dcon.prepareStatement(\"insert into biodata(firstname, lastname, photo)\"+\"values(?,?,?)\");\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003epsmt.setString(1,firstname);\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003epsmt.setString(2,lastname);\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003efis\u003dnew FileInputStream(image);\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003epsmt.setBinaryStream(3, (InputStream)fis, (int)(image.length()));\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eint s \u003d psmt.executeUpdate();\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eif(s\u0026gt;0) {\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e%\u0026gt;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u0026lt;b\u0026gt;\u0026lt;font color\u003d\"Blue\"\u0026gt;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u0026lt;% out.println(\"Image Uploaded successfully!!!\"); %\u0026gt;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u0026lt;/font\u0026gt;\u0026lt;/b\u0026gt;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u0026lt;%\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e}\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eelse\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e{\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eout.println(\"Failed to upload image.\");\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e}\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003econ.close();\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003epsmt.close();\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e}\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003ecatch(Exception ex)\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e{\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eout.println(\"Error in connection : \"+ex);\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e}\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e%\u0026gt;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u0026lt;/body\u0026gt;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/html\u0026gt;\u0026nbsp;\u003c/span\u003e\u003c/div\u003e\n\u003cdiv\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cb\u003eOutput:\u003c/b\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\n\u003ca href\u003d\"https://1.bp.blogspot.com/-5GxfASIU40k/WGt8pCog2sI/AAAAAAAADM4/T8ol-Gup_3ExCz5QyTVsPcg5Qxjjx-vBwCLcB/s1600/uploadimagebackend.jpeg\" imageanchor\u003d\"1\" style\u003d\"margin-left: 1em; margin-right: 1em;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cimg border\u003d\"0\" src\u003d\"https://1.bp.blogspot.com/-5GxfASIU40k/WGt8pCog2sI/AAAAAAAADM4/T8ol-Gup_3ExCz5QyTVsPcg5Qxjjx-vBwCLcB/s1600/uploadimagebackend.jpeg\" /\u003e\u003c/span\u003e\u003c/a\u003e\u003c/div\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u003c/span\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cb\u003e\u003cbr /\u003e\u003c/b\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cb\u003edisplayimage.jsp\u003c/b\u003e\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cdiv style\u003d\"background: lightgreen;\"\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;%@ page language\u003d\"java\" contentType\u003d\"text/html; charset\u003dISO-8859-1\"\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; pageEncoding\u003d\"ISO-8859-1\"%\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \"http://www.w3.org/TR/html4/loose.dtd\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;html\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;head\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;meta http-equiv\u003d\"Content-Type\" content\u003d\"text/html; charset\u003dISO-8859-1\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;title\u0026gt;Image Upload to MySQL Database Demo\u0026lt;/title\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/head\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;body\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp;\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;form method\u003d\"post\" action\u003d\"displayimagebackend.jsp\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;table border\u003d\"0\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td\u0026gt;First Name: \u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td\u0026gt;\u0026lt;input type\u003d\"text\" name\u003d\"firstname\" size\u003d\"50\"/\u0026gt;\u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td\u0026gt;Last Name: \u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td\u0026gt;\u0026lt;input type\u003d\"text\" name\u003d\"lastname\" size\u003d\"50\"/\u0026gt;\u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;td colspan\u003d\"2\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;input type\u003d\"submit\" value\u003d\"Show Image\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/td\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/tr\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/table\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026lt;/form\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp;\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/body\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/html\u0026gt;\u0026nbsp;\u003c/span\u003e\u003c/div\u003e\n\u003cdiv\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cb\u003eOutput:\u003c/b\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\n\u003c/div\u003e\n\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\n\u003c/div\u003e\n\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\n\u003ca href\u003d\"https://4.bp.blogspot.com/-bPJG_6bqqPw/WGuCIhPGuwI/AAAAAAAADNc/CVsNN9xSj-Q69UbKnZBB8ZckUjyPib2gwCLcB/s1600/displayimage.jpeg\" imageanchor\u003d\"1\" style\u003d\"margin-left: 1em; margin-right: 1em;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cimg border\u003d\"0\" src\u003d\"https://4.bp.blogspot.com/-bPJG_6bqqPw/WGuCIhPGuwI/AAAAAAAADNc/CVsNN9xSj-Q69UbKnZBB8ZckUjyPib2gwCLcB/s1600/displayimage.jpeg\" /\u003e\u003c/span\u003e\u003c/a\u003e\u003c/div\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cb\u003e\u003cbr /\u003e\u003c/b\u003e\u003c/span\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cb\u003e\u003cbr /\u003e\u003c/b\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cb\u003edisplayimagebackend.jsp\u003c/b\u003e\u003c/span\u003e\u003c/div\u003e\n\u003cdiv style\u003d\"background: lightgreen;\"\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u0026lt;%@ page import\u003d\"java.io.*,java.util.*,java.sql.*\"%\u0026gt;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;%@ page import\u003d\"javax.servlet.http.*,javax.servlet.*\" %\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;%@ taglib uri\u003d\"http://java.sun.com/jsp/jstl/core\" prefix\u003d\"c\"%\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;%@ taglib uri\u003d\"http://java.sun.com/jsp/jstl/sql\" prefix\u003d\"sql\"%\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;html\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;head\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/head\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;body\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;div style\u003d\"background-color:SlateGray\"\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/div\u0026gt;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u0026lt;%\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eString firstname \u003d request.getParameter(\"firstname\");\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eString lastname \u003d request.getParameter(\"lastname\");\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eBlob image \u003d null;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eConnection con \u003d null;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ebyte[] imgData \u003d null ;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eStatement stmt \u003d null;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eResultSet rs \u003d null;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003etry\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e{\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eClass.forName(\"com.mysql.jdbc.Driver\");\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003econ \u003d DriverManager.getConnection(\"jdbc:mysql://localhost:3306/test\",\"test\",\"123\");\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003estmt \u003d con.createStatement();\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ers \u003d stmt.executeQuery(\"select photo from biodata where firstname\u003d\"+\"'\"+firstname+\"'\"+\" \u0026amp;\u0026amp; \"+\"lastname\u003d\"+\"'\"+lastname+\"'\");\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eif (rs.next())\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e{\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eimage \u003d rs.getBlob(1);\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eimgData \u003d image.getBytes(1,(int)image.length());\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e}\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eelse\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e{\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eout.println(\"Image not found.\");\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ereturn;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e}\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e// display the image\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003eresponse.setContentType(\"image/gif\");\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eOutputStream o \u003d response.getOutputStream();\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eo.write(imgData);\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eo.flush();\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eo.close();\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e}\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003ecatch (Exception e)\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e{\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eout.println(\"Unable To Display image\");\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eout.println(\"Image Display Error\u003d\" + e.getMessage());\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ereturn;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e}\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003efinally\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e{\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003etry\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e{\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ers.close();\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003estmt.close();\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003econ.close();\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e}\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003ecatch (SQLException e)\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e{\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ee.printStackTrace();\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e}\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e}\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e%\u0026gt;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: medium;\"\u003e\u0026lt;/body\u0026gt;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026lt;/html\u0026gt;\u0026nbsp;\u003c/span\u003e\u003c/div\u003e\n\u003cdiv\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cb\u003eOutput:\u003c/b\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\n\u003ca href\u003d\"https://1.bp.blogspot.com/-mh9jz0roztM/WGt9fRqn0JI/AAAAAAAADNE/AJp8o1BaFPQ_Of5UAhE7iJHfKQQgGp2cACLcB/s1600/displayimagebackend.jpeg\" imageanchor\u003d\"1\" style\u003d\"margin-left: 1em; margin-right: 1em;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cimg border\u003d\"0\" src\u003d\"https://1.bp.blogspot.com/-mh9jz0roztM/WGt9fRqn0JI/AAAAAAAADNE/AJp8o1BaFPQ_Of5UAhE7iJHfKQQgGp2cACLcB/s1600/displayimagebackend.jpeg\" /\u003e\u003c/span\u003e\u003c/a\u003e\u003c/div\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\u003c/div\u003e\n\u003cdiv style\u003d\"text-align: center;\"\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: medium;\"\u003e\u003ca href\u003d\"http://www.comrevo.com/2016/08/web-designing.html\" target\u003d\"_blank\"\u003e\u003cb\u003e\u003c/b\u003e\u003c/a\u003e\u003c/span\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cbr /\u003e\n\u003ccenter\u003e\n\u003ctable border\u003d\"1\"\u003e\u003ctbody\u003e\n\u003ctr\u003e\u003cth\u003e\u003ca href\u003d\"http://www.comrevo.com/2016/08/web-designing.html\" target\u003d\"_blank\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003eCheck Other Posts on Web Designing\u003c/span\u003e\u003c/a\u003e\u003c/th\u003e\u003c/tr\u003e\n\u003c/tbody\u003e\u003c/table\u003e\n\u003c/center\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003ca href\u003d\"http://www.comrevo.com/2016/08/web-designing.html\" target\u003d\"_blank\"\u003e\u003cb\u003e\u003c/b\u003e\u003c/a\u003e\u003c/span\u003e\u003c/div\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n"},"link":[{"rel":"replies","type":"application/atom+xml","href":"https://www.comrevo.com/feeds/8428938104244973470/comments/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"https://www.comrevo.com/2017/01/how-to-insert-and-retrieve-image-from-mysql-database-in-jsp.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"https://www.blogger.com/feeds/913600556879440043/posts/default/8428938104244973470"},{"rel":"self","type":"application/atom+xml","href":"https://www.blogger.com/feeds/913600556879440043/posts/default/8428938104244973470"},{"rel":"alternate","type":"text/html","href":"https://www.comrevo.com/2017/01/how-to-insert-and-retrieve-image-from-mysql-database-in-jsp.html","title":"How to insert and retrieve image from mysql database in jsp"}],"author":[{"name":{"$t":"Parag Jambhulkar"},"uri":{"$t":"https://www.blogger.com/profile/13991750622483538113"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"35","height":"35","src":"//www.blogger.com/img/blogger_logo_round_35.png"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https://4.bp.blogspot.com/-T7JvskHckKU/WGt6N7ggGqI/AAAAAAAADMk/YGE-0HnuEwkHXffVkANhQM8YR_sROVK1ACLcB/s72-c/biodata%2Bimage.jpeg","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-913600556879440043.post-573515798936081527"},"published":{"$t":"2015-12-26T21:10:00.004+05:30"},"updated":{"$t":"2023-02-01T15:12:10.134+05:30"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Database"},{"scheme":"http://www.blogger.com/atom/ns#","term":"SQL"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Mysql"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Website Designing"},{"scheme":"http://www.blogger.com/atom/ns#","term":"General"}],"title":{"type":"text","$t":"Mysql Tutorial - Basic SQL Queries"},"content":{"type":"html","$t":"\u003cdiv dir\u003d\"ltr\" style\u003d\"text-align: left;\" trbidi\u003d\"on\"\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; In this post (tutorial), we will see basic sql queries which we need for database (e.g. Mysql) operations.\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003ca name\u003d'more'\u003e\u003c/a\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e1. Installing Mysql on Ubuntu\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003esudo apt-get install mysql-server\u003c/span\u003e \u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e2. Getting Mysql prompt\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax: \u003c/u\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003emysql -u root -p\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003ci\u003eNote:\u003c/i\u003e Enter the Mysql root user password to get Mysql prompt. \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e3. Showing all users\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect user from mysql.user;\u003c/span\u003e\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e \u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e4. Creating New User\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ecreate user 'username'@'localhost' identified by 'password';\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e5. Granting permissions to new user\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003egrant all privileges on *.* to 'username'@'localhost';\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eflush privileges;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eNote:\u003c/u\u003e\u0026nbsp; We can allocate specific privileges like CREATE, DROP etc.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eFollowing is the list of privileges we can allocate:\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eALL PRIVILEGES – \u003cu\u003egrants all privileges to the MySQL user\u003c/u\u003e\u003cbr /\u003eCREATE – \u003cu\u003eallows the user to create databases and tables\u003c/u\u003e\u003cbr /\u003eDROP - \u003cu\u003eallows the user to drop databases and tables\u003c/u\u003e\u003cbr /\u003eDELETE - \u003cu\u003eallows the user to delete rows from specific MySQL table\u003c/u\u003e\u003cbr /\u003eINSERT - \u003cu\u003eallows the user to insert rows into specific MySQL table\u003c/u\u003e\u003cbr /\u003eSELECT – \u003cu\u003eallows the user to read the database\u003c/u\u003e\u003cbr /\u003eUPDATE - \u003cu\u003eallows the user to update table rows\u003c/u\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; Here \u003cb\u003e*.*\u003c/b\u003e represents \u003cb\u003eDatabase.Table\u003c/b\u003e.\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e* is wildcard symbol which specifies all databases and all tables.\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cb\u003eDatabase.*\u003c/b\u003e means all tables in the database \u003cb\u003eDatabase.\u003c/b\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e6. Exiting from Mysql prompt\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eexit\u0026nbsp;\u003c/span\u003e\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e \u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e7. Logging into mysql prompt by new user\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003emysql -u username -p\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e8. Removing user\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003edrop user 'username'@'localhost';\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e9. Showing existing databases\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eshow databases;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e10. Creating new database\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ecreate database databasename;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e11. Using particular Database\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003euse databasename\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e12. Deleting database\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003edrop database databasename;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e13. Creating Table\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ecreate table tablename\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e(\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003efirst-column-name datatype(size) primary key,\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003esecond-column-name datatype(size),\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003ethird-column-name datatype(size)\u003c/span\u003e,\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e.\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e.\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e.\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003enth-column-name datatype(size)\u0026nbsp;\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e);\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003ci\u003eNote:\u003c/i\u003e Datatypes are int or integer, varchar. Size is number of characters or digits.\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ee.g.\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ecreate table student\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e(\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003erollno int(5),\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ename varchar(20),\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ecity varchar(10),\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003econtactno int(11)\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e); \u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e14. Showing description/details of table\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\u003c/b\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax\u003c/u\u003e:\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003edesc tablename;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003c/span\u003e\u003c/b\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003ee.g.\u003c/u\u003e\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003edesc student;\u003c/span\u003e\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e15. Showing list of tables in selected database\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax\u003c/u\u003e:\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eshow tables;\u0026nbsp;\u003c/span\u003e\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e \u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e16. Removing Table\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003edrop table tablename; \u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e17. Inserting record (row) to table\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003einsert into tablename(columnname1, columnname2, columnname3...) values('value1', 'value2', 'value3'...);\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003ee.g. inserting record into above table student\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003einsert into student(rollno,name,city,contactno) values(1234,'Parag','Pune',909090909);\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eOR\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003einsert into student values(1234,'Parag','Pune',9090909090); \u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e18. Updating/Altering Table definition\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003ci\u003e\u003cspan style\u003d\"font-size: large;\"\u003eAdding new column to table\u003c/span\u003e\u003c/i\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ealter table tablename add columnname datatype(size);\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cu\u003e\u003ci\u003e\u003cspan style\u003d\"font-size: large;\"\u003eChanging existing coulmn\u003c/span\u003e\u003c/i\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ealter table tablename modify columnname datatype(size);\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e19. Updating record from table\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eupdate tablename\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eset columnname1\u003dvalue1,\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp;\u0026nbsp;\u0026nbsp; columnname2\u003dvalue2, \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; .\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; .\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; .\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; columnnamen\u003dvaluen\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ewhere columnname\u003dvalue;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003ee.g.\u003c/u\u003e\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eupdate student\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eset city\u003d'Mumbai'\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ewhere name\u003d'Parag'; \u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e20. Deleting records from table\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003edelete from tablename where columnname\u003d'value';\u0026nbsp;\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e21. Showing records(data) from table\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003ci\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSelecting all records with values of all columns\u003c/span\u003e\u003c/i\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect * from tablename;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ee.g.\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect * from student; \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cu\u003e\u003ci\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSelecting all \u003c/span\u003e\u003cspan style\u003d\"font-size: large;\"\u003erecords with values of few columns\u003c/span\u003e\u003c/i\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect columnname1, columnname2, ...\u0026nbsp; from tablename;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003ee.g.\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect name,city from student;\u003c/span\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003ci\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSelecting few \u003c/span\u003e\u003cspan style\u003d\"font-size: large;\"\u003erecords with values of few columns\u003c/span\u003e\u003c/i\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003eselect columnname1, columnname2, ...\u0026nbsp; from tablename where columnname\u003d'value';\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003ee.g.\u003c/u\u003e\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003eselect name from student\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003ewhere city\u003d'Mumbai';\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e22. AND\u003c/span\u003e\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; It is used to mention multiple conditions. Only those records are shown which follows all the conditions.\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003eselect columnnames from tablename\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003ewhere\u0026nbsp;\u003c/span\u003e\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cspan style\u003d\"font-size: large;\"\u003ecolumnname1\u003dvalue1 AND columnname2\u003dvalue2;\u0026nbsp;\u003c/span\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cdiv\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e23. OR\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; It is also used to mention multiple conditions. Here, only those records are shown which follow atleast one condition.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect columnnames from tablename\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ewhere\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ecolumnname\u003dvalue1 OR columnname2\u003dvalue2;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e24. BETWEEN\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; It is used show records where values are in the given range.\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect columnnanes from tablename\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ewhere\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003ecolumnname BETWEEN value1 AND value2;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e25. AS\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; It is used to mention alias of the column name.\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u0026nbsp;\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect columnname AS alias from tablename; \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e26. AVG()\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; It is an aggregate function. It is used to show average of numeric values of any numeric column.\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect AVG(columnname) from tablename;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e27. COUNT()\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; It is an aggregate function. It is used to give number of records where column is not null.\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect COUNT(columnname) from tablename;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e28. GROUP BY\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp;\u0026nbsp; It is used with aggregate functions. It is used to arrange identical data in groups.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect columnname, COUNT(*) from tablename\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eGROUP BY columnname;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003ee.g.\u0026nbsp;\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect city, COUNT(*) from student\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eGROUP BY city;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e29. HAVING\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; It is used with aggregate functions and GROUP BY to mention any condition or constraint.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect columnname, COUNT(*) from tablename\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eGROUP BY columnname\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eHAVING condition;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003ee.g.\u003c/u\u003e\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect city, COUNT(*) from student\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eGROUP BY city\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eHAVING COUNT(*)\u0026gt;1;\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e30. DISTINCT\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; It avoids repetitive\u0026nbsp; data while showing records.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect DISTINCT(columnname) from tablename;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003ee.g.\u0026nbsp;\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect DISTINCT(city) from student;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e31. SUM()\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; It is an aggregate function. It returns sum of numeric values of numeric column.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003eSyntax:\u003c/u\u003e\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect SUM(columnname) from tablename;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003ee.g.\u003c/u\u003e\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect SUM(marks) from student;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e32. INNER JOIN\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; It is used to combine data from multiple tables. INNER JOIN shows records for the values which are present in all the tables.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect columnnames from tablename1 JOIN tablename2\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eON tablename1.columnname\u003dtablename2.columnname;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003ee.g.\u0026nbsp;\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect * from student JOIN studentmarks\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eON\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003estudent.rollno\u003dstudentmarks.rollno;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003e33. OUTER JOIN\u003c/span\u003e\u003c/b\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; Like INNER JOIN, it is used to combine data from different tables. Difference is that it combines records(rows) with similar data as well as dissimilar data.\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eSyntax:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect columnnames from tablename1 LEFT/RIGHT JOIN tablename2\u0026nbsp;\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eON tablename1.columnname\u003dtablename2.columnname;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003ee.g.\u0026nbsp;\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect * from student LEFT JOIN studentmarks\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eON\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003estudent.rollno\u003dstudentmarks.rollno;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eNote:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eLEFT JOIN shows columns from left table and null values for right table.\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003ee.g.\u0026nbsp;\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eselect * from student RIGHT JOIN studentmarks\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eON\u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003estudent.rollno\u003dstudentmarks.rollno;\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cu\u003e\u003cspan style\u003d\"font-size: large;\"\u003eNote:\u003c/span\u003e\u003c/u\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003eRIGHT JOIN shows columns from right table and null values for left table.\u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp;\u0026nbsp; \u003c/span\u003e\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\u003c/div\u003e\n\u003cdiv style\u003d\"text-align: center;\"\u003e\n\u003ccenter\u003e\n\u003ctable border\u003d\"1\"\u003e \u003ctbody\u003e\n\u003ctr\u003e\u003cth\u003eCheck Other Posts on Database\u0026nbsp;\u003ca href\u003d\"http://www.comrevo.com/2016/09/database.html\" target\u003d\"_blank\"\u003ehttp://www.comrevo.com/2016/09/database.html\u003c/a\u003e\u003c/th\u003e\u003c/tr\u003e\n\u003c/tbody\u003e\u003c/table\u003e\n\u003c/center\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003ca href\u003d\"http://www.comrevo.com/2016/08/web-designing.html\" target\u003d\"_blank\"\u003e\u003cb\u003e\n\u003c/b\u003e\u003c/a\u003e\u003c/span\u003e\u003c/div\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003e\u003ci\u003eNext:\u003c/i\u003e\u003c/u\u003e\u0026nbsp;\u003ca href\u003d\"http://www.comrevo.com/2015/12/abbreviations-in-computer-science.html\"\u003eAbbreviations in Computer Science \u003c/a\u003e \u003c/span\u003e\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cu\u003e\u003ci\u003ePrevious:\u003c/i\u003e\u003c/u\u003e \u003ca href\u003d\"http://www.comrevo.com/2015/11/basic-linux-commands-with-examples.html\"\u003eBasic Linux Commands with Examples \u003c/a\u003e\u003c/span\u003e\n\u003cbr /\u003e\n\u003cspan style\u003d\"font-size: large;\"\u003e\u003cbr /\u003e\u003c/span\u003e\u003c/div\u003e\n"},"link":[{"rel":"replies","type":"application/atom+xml","href":"https://www.comrevo.com/feeds/573515798936081527/comments/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"https://www.comrevo.com/2015/12/mysql-tutorial-basic-sql-queries.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"https://www.blogger.com/feeds/913600556879440043/posts/default/573515798936081527"},{"rel":"self","type":"application/atom+xml","href":"https://www.blogger.com/feeds/913600556879440043/posts/default/573515798936081527"},{"rel":"alternate","type":"text/html","href":"https://www.comrevo.com/2015/12/mysql-tutorial-basic-sql-queries.html","title":"Mysql Tutorial - Basic SQL Queries"}],"author":[{"name":{"$t":"Parag Jambhulkar"},"uri":{"$t":"https://www.blogger.com/profile/13991750622483538113"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"35","height":"35","src":"//www.blogger.com/img/blogger_logo_round_35.png"}}],"thr$total":{"$t":"0"}}]}});