Python PyMySQL delete record

So far, I have discussed about connection establishment, create table, insert record, read records (select statement), update record. In this article we are going to learn about delete a record. Following is the table which I am going to delete a record. the table name is emp_info emp_id emp_name emp_age 1 Raj 22 2 Rahul […]

Python PyMySQL Update Record

In some cases, we may want to update table data using update sql statement. Lets see how can we update. The table which I am using to update record is as below. emp_id emp_name emp_age 1 Raj 22 2 Rahul 24 3 Vivek 26 4 Ajay 28 5 Suraj 29 In the above table, lets […]

Python PyMySQL Create Table

The first job, in python database project can be creating a table. In this article, we will learn how to create a table in mysql database using python and pymysql. (See following table example) emp_id emp_name emp_age 1 Raj 22 2 Rahul 24 3 Vivek 26 4 Ajay 28 5 Suraj 29 Lets see how […]

Python PyMySQL Establish Connection

In this first article of Python PyMySQL Tutorial, we are going to learn how to establish database connection with mysql database. Before proceeding further, you must have following knowledge Basics of Python MySQL commands (create table, insert row, select row, update row, delete row etc.) To establish connection with a database like MYSQL server, we […]