{"id":6878,"date":"2021-06-04T12:01:20","date_gmt":"2021-06-04T06:31:20","guid":{"rendered":"https:\/\/python-programs.com\/?page_id=6878"},"modified":"2021-08-02T09:46:00","modified_gmt":"2021-08-02T04:16:00","slug":"python-mysql-tutorial","status":"publish","type":"page","link":"https:\/\/python-programs.com\/python-mysql-tutorial\/","title":{"rendered":"Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial"},"content":{"rendered":"<p>Python Programming Language is one of the popular programming languages used by software developers for various developments. Today, we are going to discuss completely the concept of Python Mysql database. Just have a look at this <a href=\"https:\/\/python-programs.com\/\">BTech Geeks<\/a> Python MySQL Tutorial for Beginners and learn What is MySQL Database in Python, the List of topics involved in it, Prerequisites, Installation of Mysql connector python of windows and Linux, How to Install MySQL Connector Library for Python, etc.<\/p>\n<ul>\n<li><a href=\"#What_is_MySQL_Database_in_Python?\">What is MySQL Database in Python?<\/a><\/li>\n<li><a href=\"#List_of_Concepts_in_Python_Mysql_Tutorial\">List of Concepts in Python Mysql Tutorial<\/a><\/li>\n<li><a href=\"#Prerequisites_for_Learning_Python_MySQLdb\">Prerequisites for Learning Python MySQLdb<\/a><\/li>\n<li><a href=\"#How_to_Install_Python_MySQL_Connector_Library?\">How to Install Python MySQL Connector Library?<\/a><\/li>\n<li><a href=\"#Command_to_Download_&amp;_Install_\">Command to Download &amp; Install &#8220;MySQL Connector&#8221;<\/a><\/li>\n<li><a href=\"#Installation_of_MySQL_Connector_Python_in_Linux\/Unix\">Installation of MySQL Connector Python in Linux\/Unix<\/a><\/li>\n<li><a href=\"#Steps_to_Work_with_MySQL_in_Python\">Steps to Work with MySQL in Python<\/a><\/li>\n<li><a href=\"#Python_MySQL_Example\">Python MySQL Example<\/a><\/li>\n<\/ul>\n<h2><a id=\"What_is_MySQL_Database_in_Python?\"><\/a>What is MySQL Database in Python?<\/h2>\n<p>In Python, MySQL Database is an interface used for connecting to a MySQL database server. It executes the Python Database API v2.0 and is grown on tip of the MySQL C API. Enabling the python programs to access Mysql databases can be done by MySQL Connector\/Python with an API.<\/p>\n<h2><a id=\"List_of_Concepts_in_Python_Mysql_Tutorial\"><\/a>List of Concepts in Python Mysql Tutorial<\/h2>\n<p>By going through this\u00a0MySQL Python tutorial, beginners and professionals will learn all the basic to advanced levels of using MySQL with Python, along with all necessary functions and queries explained in detail in the below available tutorials. Click on the links and quickly understand the sub-concepts of the python MySQL database.<\/p>\n<ul>\n<li>Inserting multiple rows in MySQL<\/li>\n<li>MySQL add primary key multiple columns<\/li>\n<li>Error Code: 1364 [Solved] Field doesn\u2019t have a default value<\/li>\n<li>MySQL add primary key to existing table<\/li>\n<li>MySQL string contains query<\/li>\n<li>MySQL get data by string length<\/li>\n<li>Mysql update set multiple columns<\/li>\n<li>Mysql update set multiple rows<\/li>\n<li>Mysql update column with value from another table<\/li>\n<li>MySQL Update with Inner Join<\/li>\n<li>MySQL Insert with Join<\/li>\n<li>Select all columns except one of a MySQL table<\/li>\n<li>Concatenate multiple MySQL rows to one field<\/li>\n<li>MySQL Select Multiple Values<\/li>\n<li>MySQL trigger example before insert<\/li>\n<li>MySQL trigger example after update<\/li>\n<li>MySQL trigger example before update<\/li>\n<li>MySQL trigger example after insert<\/li>\n<li>Trigger with if condition in mysql<\/li>\n<li>Create trigger on delete<\/li>\n<li>What are triggers in MySQL<\/li>\n<li>What are views in MySQL<\/li>\n<li>What are indexes in MySQL<\/li>\n<li>MySQL add index to existing table<\/li>\n<li>MySQL ADD FOREIGN KEY<\/li>\n<li>MySQL ADD COLUMN IF NOT EXISTS<\/li>\n<li>MySQL create table if not exists<\/li>\n<li>MySQL get column names<\/li>\n<li>SELECT 1 FROM TABLE<\/li>\n<li>MySQL select first row in each group<\/li>\n<li>MySQL select first row<\/li>\n<li>MySQL Select last N rows<\/li>\n<li>MySQL select last record of table<\/li>\n<li>MySQL WHERE DATE BETWEEN<\/li>\n<li>MySQL WHERE DATE GREATER THAN<\/li>\n<li>MySQL SELECT YESTERDAY\u2019S DATE<\/li>\n<li>MySQL SELECT WHERE DATE IS TODAY<\/li>\n<li>MYSQL SELECT WHERE MONTH AND YEAR<\/li>\n<li>MySQL SELECT WHERE NULL<\/li>\n<li>MySQL SELECT WHERE NOT IN<\/li>\n<li>MySQL SELECT WHERE LIKE<\/li>\n<li>MySQL SELECT WHERE IN SubQuery<\/li>\n<li>MySQL SELECT WHERE<\/li>\n<li>MySQL DELETE WITH JOIN<\/li>\n<li>MySQL : Remove whitespaces from entire column<\/li>\n<li>MySQL: Remove characters from string<\/li>\n<li>MySQL increase VARCHAR size of column without breaking existing data<\/li>\n<li>MYSQL: change column order<\/li>\n<li>MySQL: change column type to VARCHAR without losing data<\/li>\n<li>How to rename a column in MySQL<\/li>\n<li>MySQL : Change Datatype of a Column<\/li>\n<li><a href=\"https:\/\/python-programs.com\/mysql-error-1264-out-of-range-value-for-a-column\/\">MySQL: Error 1264 Out of range value for a column [Solved]<\/a><\/li>\n<li>MySQL: Loop Through Rows<\/li>\n<li>MySQL: Insert in a loop<\/li>\n<li>MySQL For Loop Example<\/li>\n<li>MySQL: Columns to Rows<\/li>\n<li>MySQL: convert rows to columns<\/li>\n<li>MySQL: get column names and datatypes of a table<\/li>\n<li>MySQL- Add multiple columns after a specific column<\/li>\n<li>MySQL- Drop\/ Delete column from table<\/li>\n<li>Difference between JOIN and UNION<\/li>\n<li>IF in SELECT statement MySQL<\/li>\n<li>Select from multiple tables MySQL<\/li>\n<li>LIMIT with OFFSET in MYSQL<\/li>\n<li>MySQL select rows by range<\/li>\n<li><a href=\"https:\/\/python-programs.com\/insert-record-if-not-exists-in-mysql\/\">INSERT record if NOT EXISTS in MySQL<\/a><\/li>\n<li>ROW_NUMBER() in MySQL<\/li>\n<li>Select count(*) with distinct<\/li>\n<li>MySQL select TOP 10 rows<\/li>\n<li>MySQL Select where Count is greater than one [Solved]<\/li>\n<li>Count with If Condition in MySQL Query<\/li>\n<li>How to get multiple counts in single MySQL query<\/li>\n<li>MySQL select row count [Everything around count()]<\/li>\n<li>MySQL select rows with date range[Solved]<\/li>\n<li>MySQL select row with max date per user [Solved]<\/li>\n<li>Retrieving the last record in each group[Solved] \u2013 MySQL<\/li>\n<li>Create Temporary Table in MySQL<\/li>\n<li>MySQL IF EXISTS DROP Table<\/li>\n<li>Every derived table must have its own alias[Solved]<\/li>\n<li><a href=\"https:\/\/python-programs.com\/mysql-delete-duplicate-rows-but-keep-one\/\">MySQL Delete Duplicate Rows but keep one<\/a><\/li>\n<li>Find duplicate rows in MySQL<\/li>\n<li>MySQL check if table exists<\/li>\n<li>Insert into a MySQL table or update if exists<\/li>\n<li>Reset AUTO_INCREMENT after Delete in MySQL<\/li>\n<li>Reset AUTO INCREMENT in MySQL<\/li>\n<li>Mysql: select rows with MAX(Column value), DISTINCT by another column<\/li>\n<li>MySQL select row with max value for each group<\/li>\n<li>MySQL select row with max value<\/li>\n<li>MYSQL INSERT WITH SELECT<\/li>\n<li>MYSQL INSERT INTO<\/li>\n<li>MYSQL: CREATE A DATABASE<\/li>\n<li>MYSQL: UNION \u2013 tutorial with examples<\/li>\n<\/ul>\n<h3><a id=\"Prerequisites_for_Learning_Python_MySQLdb\"><\/a>Prerequisites for Learning Python MySQLdb<\/h3>\n<p>Beginners and developers who are passionate about learning the MySQL Python concept, then you should have some knowledge of Python Data Types, Control Structures, Loops, etc. Also, it is mandatory to have a good grip on SQL basics before you start preparing the Mysql database in Python.<\/p>\n<p><span style=\"color: #ff6600;\">Must Check Other Python Tutorials:<\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/python-programs.com\/python-data-analysis-using-pandas\/\">Python Data Analysis Using Pandas<\/a><\/li>\n<li><a href=\"https:\/\/python-programs.com\/numpy-array-tutorial\/\">Python Numpy Array Tutorial<\/a><\/li>\n<\/ul>\n<h3><a id=\"How_to_Install_Python_MySQL_Connector_Library?\"><\/a>How to Install Python MySQL Connector Library?<\/h3>\n<p>From the following syntaxes, you can learn how to connect MySQL with Python:<\/p>\n<p>By using pip as shown below, you can install MySQL Connector Library for python 2.7 or lower versions:<\/p>\n<pre>pip install mysql-connector<\/pre>\n<p>With pip3, you can install MySQL Connector Library for Python 3 or higher version<\/p>\n<pre>pip3 install mysql-connector<\/pre>\n<h3><a id=\"Command_to_Download_&amp;_Install_\"><\/a>Command to Download &amp; Install &#8220;MySQL Connector&#8221;<\/h3>\n<pre>C:\\Users\\<\/pre>\n<p><em>Your Name<\/em><\/p>\n<pre>\\AppData\\Local\\Programs\\Python\\Python36-32\\Scripts&gt;python -m pip install mysql-connector-python<\/pre>\n<h3><a id=\"Installation_of_MySQL_Connector_Python_in_Linux\/Unix\"><\/a>Installation of MySQL Connector Python in Linux\/Unix<\/h3>\n<ul>\n<li>Firstly, you guys should get the RPM package for Linux\/Unix by downloading from the Official site:\u00a0<a href=\"https:\/\/www.mysql.com\/downloads\/\" rel=\"nofollow noreferrer\">https:\/\/www.mysql.com\/downloads\/<\/a><\/li>\n<li>Next, use the following command in the terminal:<\/li>\n<\/ul>\n<pre>rpm -i &lt;Package_name&gt;<\/pre>\n<pre>Example rpm -i MySQL-5.0.9.0.i386.rpm<\/pre>\n<ul>\n<li>Finally, now you can check in Linux by using the following command<\/li>\n<\/ul>\n<pre>mysql --version<\/pre>\n<h3><a id=\"Steps_to_Work_with_MySQL_in_Python\"><\/a>Steps to Work with MySQL in Python<\/h3>\n<p>The below process or steps should be followed in python for working with MySQL:<\/p>\n<ol>\n<li>Initially, Connect to the database.<\/li>\n<li>Then, create an object for your database.<\/li>\n<li>After successful creation of an Object, execute the SQL query.<\/li>\n<li>Retrieve records from the result.<\/li>\n<li>Finally, inform the Database if you perform any changes to the table.<\/li>\n<\/ol>\n<h3><a id=\"Python_MySQL_Example\"><\/a>Python MySQL Example<\/h3>\n<p>The illustrated example will connect to the MySQL database in the python program.<\/p>\n<pre>import pymysql\r\n\r\n#database connection\r\nconnection = pymysql.connect(host=\"localhost\",user=\"root\",passwd=\"\",database=\"databaseName\" )\r\ncursor = connection.cursor()\r\n# some other statements with the help of cursor\r\nconnection.close()<\/pre>\n<p>For more examples on MySQL Python, please go through the link given here: <strong><a href=\"https:\/\/python-programs.com\/python-programming-examples-with-output\/\">Python Programming Examples with Output\u00a0<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Python Programming Language is one of the popular programming languages used by software developers for various developments. Today, we are going to discuss completely the concept of Python Mysql database. Just have a look at this BTech Geeks Python MySQL Tutorial for Beginners and learn What is MySQL Database in Python, the List of topics &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/python-programs.com\/python-mysql-tutorial\/\"> <span class=\"screen-reader-text\">Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":7857,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"spay_email":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial - Python Programs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/python-programs.com\/python-mysql-tutorial\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial - Python Programs\" \/>\n<meta property=\"og:description\" content=\"Python Programming Language is one of the popular programming languages used by software developers for various developments. Today, we are going to discuss completely the concept of Python Mysql database. Just have a look at this BTech Geeks Python MySQL Tutorial for Beginners and learn What is MySQL Database in Python, the List of topics &hellip; Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/python-programs.com\/python-mysql-tutorial\/\" \/>\n<meta property=\"og:site_name\" content=\"Python Programs\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/btechgeeks\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-02T04:16:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/python-programs.com\/wp-content\/uploads\/2021\/06\/Python-Mysql-Tutorial-.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@btech_geeks\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/python-programs.com\/#organization\",\"name\":\"BTech Geeks\",\"url\":\"https:\/\/python-programs.com\/\",\"sameAs\":[\"https:\/\/www.instagram.com\/btechgeeks\/\",\"https:\/\/www.linkedin.com\/in\/btechgeeks\",\"https:\/\/in.pinterest.com\/btechgeek\/\",\"https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg\",\"https:\/\/www.facebook.com\/btechgeeks\",\"https:\/\/twitter.com\/btech_geeks\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/python-programs.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"contentUrl\":\"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"width\":350,\"height\":70,\"caption\":\"BTech Geeks\"},\"image\":{\"@id\":\"https:\/\/python-programs.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/python-programs.com\/#website\",\"url\":\"https:\/\/python-programs.com\/\",\"name\":\"Python Programs\",\"description\":\"Python Programs with Examples, How To Guides on Python\",\"publisher\":{\"@id\":\"https:\/\/python-programs.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/python-programs.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/python-programs.com\/python-mysql-tutorial\/#primaryimage\",\"url\":\"https:\/\/python-programs.com\/wp-content\/uploads\/2021\/06\/Python-Mysql-Tutorial-.png\",\"contentUrl\":\"https:\/\/python-programs.com\/wp-content\/uploads\/2021\/06\/Python-Mysql-Tutorial-.png\",\"width\":1280,\"height\":720,\"caption\":\"Python Mysql Tutorial\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/python-programs.com\/python-mysql-tutorial\/#webpage\",\"url\":\"https:\/\/python-programs.com\/python-mysql-tutorial\/\",\"name\":\"Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial - Python Programs\",\"isPartOf\":{\"@id\":\"https:\/\/python-programs.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/python-programs.com\/python-mysql-tutorial\/#primaryimage\"},\"datePublished\":\"2021-06-04T06:31:20+00:00\",\"dateModified\":\"2021-08-02T04:16:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/python-programs.com\/python-mysql-tutorial\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/python-programs.com\/python-mysql-tutorial\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/python-programs.com\/python-mysql-tutorial\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/python-programs.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial - Python Programs","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/python-programs.com\/python-mysql-tutorial\/","og_locale":"en_US","og_type":"article","og_title":"Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial - Python Programs","og_description":"Python Programming Language is one of the popular programming languages used by software developers for various developments. Today, we are going to discuss completely the concept of Python Mysql database. Just have a look at this BTech Geeks Python MySQL Tutorial for Beginners and learn What is MySQL Database in Python, the List of topics &hellip; Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial Read More &raquo;","og_url":"https:\/\/python-programs.com\/python-mysql-tutorial\/","og_site_name":"Python Programs","article_publisher":"https:\/\/www.facebook.com\/btechgeeks","article_modified_time":"2021-08-02T04:16:00+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/python-programs.com\/wp-content\/uploads\/2021\/06\/Python-Mysql-Tutorial-.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@btech_geeks","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/python-programs.com\/#organization","name":"BTech Geeks","url":"https:\/\/python-programs.com\/","sameAs":["https:\/\/www.instagram.com\/btechgeeks\/","https:\/\/www.linkedin.com\/in\/btechgeeks","https:\/\/in.pinterest.com\/btechgeek\/","https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg","https:\/\/www.facebook.com\/btechgeeks","https:\/\/twitter.com\/btech_geeks"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/python-programs.com\/#\/schema\/logo\/image\/","url":"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","contentUrl":"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","width":350,"height":70,"caption":"BTech Geeks"},"image":{"@id":"https:\/\/python-programs.com\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/python-programs.com\/#website","url":"https:\/\/python-programs.com\/","name":"Python Programs","description":"Python Programs with Examples, How To Guides on Python","publisher":{"@id":"https:\/\/python-programs.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/python-programs.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/python-programs.com\/python-mysql-tutorial\/#primaryimage","url":"https:\/\/python-programs.com\/wp-content\/uploads\/2021\/06\/Python-Mysql-Tutorial-.png","contentUrl":"https:\/\/python-programs.com\/wp-content\/uploads\/2021\/06\/Python-Mysql-Tutorial-.png","width":1280,"height":720,"caption":"Python Mysql Tutorial"},{"@type":"WebPage","@id":"https:\/\/python-programs.com\/python-mysql-tutorial\/#webpage","url":"https:\/\/python-programs.com\/python-mysql-tutorial\/","name":"Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial - Python Programs","isPartOf":{"@id":"https:\/\/python-programs.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/python-programs.com\/python-mysql-tutorial\/#primaryimage"},"datePublished":"2021-06-04T06:31:20+00:00","dateModified":"2021-08-02T04:16:00+00:00","breadcrumb":{"@id":"https:\/\/python-programs.com\/python-mysql-tutorial\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/python-programs.com\/python-mysql-tutorial\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/python-programs.com\/python-mysql-tutorial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/python-programs.com\/"},{"@type":"ListItem","position":2,"name":"Python Mysql Tutorial PDF | Learn MySQL Concepts in Python from Free Python Database Tutorial"}]}]}},"_links":{"self":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/pages\/6878"}],"collection":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/comments?post=6878"}],"version-history":[{"count":9,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/pages\/6878\/revisions"}],"predecessor-version":[{"id":15823,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/pages\/6878\/revisions\/15823"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/media\/7857"}],"wp:attachment":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/media?parent=6878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}