{"id":30792,"date":"2022-07-24T12:21:06","date_gmt":"2022-07-24T12:21:06","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=30792"},"modified":"2022-12-23T05:48:07","modified_gmt":"2022-12-23T05:48:07","slug":"python-tutorials-database-operations-using-python-mysql","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/python-tutorials-database-operations-using-python-mysql\/","title":{"rendered":"Python Tutorials: Database operations using python &#8211; mysql"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Step 1 &#8211; Install MYSQL Server<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>https:\/\/www.devopsschool.com\/blog\/how-to-download-and-install-mysql-in-macos-10\/<\/li><li>https:\/\/www.devopsschool.com\/tutorial\/mysql\/how-to-install-mysql-on-centos-7.html<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Step 2 &#8211; Install python mysql connector using PIP3<\/h2>\n\n\n\n<p>$ sudo pip3 install mysql-connector-python<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 3 &#8211; Using Python &#8211; Check a mysql Connection<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Step 4 &#8211; Using Python &#8211; Create a database<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Step 5 &#8211; Using Python &#8211; Create a Table<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Step 6 &#8211; Using Python &#8211; Insert Row Ops<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Step 7 &#8211; Using Python &#8211; Read Row Ops<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Step 8 &#8211; Using Python &#8211; Update Row Ops<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Step 9 &#8211; Using Python &#8211; Delete Row Ops<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/devops-school\/eab2f34e05145b9227ba413b1aa42da7.js\"><\/script>\n","protected":false},"excerpt":{"rendered":"<p>Step 1 &#8211; Install MYSQL Server https:\/\/www.devopsschool.com\/blog\/how-to-download-and-install-mysql-in-macos-10\/ https:\/\/www.devopsschool.com\/tutorial\/mysql\/how-to-install-mysql-on-centos-7.html Step 2 &#8211; Install python mysql connector using PIP3 $ sudo pip3 install mysql-connector-python Step 3 &#8211; Using Python &#8211; Check a&#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[2],"tags":[],"class_list":["post-30792","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/30792","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=30792"}],"version-history":[{"count":2,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/30792\/revisions"}],"predecessor-version":[{"id":30795,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/30792\/revisions\/30795"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=30792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=30792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=30792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}