---
title: "Database activities in Python"  
description: "Database activities in Python"  
author: "Anonymous User"  
published: 2018-07-09  
updated: 2018-07-09  
canonical: https://www.mindstick.com/forum/34595/database-activities-in-python  
category: "python"  
tags: ["python-3.4", "python"]  
reading_time: 2 minutes  

---

# Database activities in Python

how to Create, [delete](https://www.mindstick.com/forum/33620/how-to-delete-record-from-list-in-mvc-using-ajax), [select](https://www.mindstick.com/forum/160534/orderby-then-select-vs-select-then-orderby-performance), [insert](https://www.mindstick.com/blog/173/executing-insert-delete-or-update-query-in-sqlserver-using-ado-dot-net), [ordered](https://www.mindstick.com/forum/156534/difference-between-ordered-and-unordered-list-in-html) by [activities](https://www.mindstick.com/interview/2589/describe-android-activities-in-brief) of [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) in [Python](https://www.mindstick.com/articles/75378/simple-yet-useful-tips-when-using-python) ?

## Replies

### Reply by Prakash nidhi Verma

Database Activities :

Creating a Table :

```
import mysql.connector mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database: "mydatabase"
)
mycursor = mydb.cursor()
mycursor.execute("CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))")
```

\

Insert Into Table:

```
import mysql.connector mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
val = ("mindstick", "Allahabad")
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowsaffected, "record inserted.")
```

Python MySQL Select From:

```
import mysql.connector mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM customers")
myresult = mycursor.fetchall()
for x in myresult:
  print(x)
```

Python MySQL Order By:

```
import mysql.connector mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
sql = "SELECT * FROM customers ORDER BY name"
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:
  print(x)
```

Delete Record:

```
import mysql.connector mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
sql = "DELETE FROM customers WHERE address = 'Tashkhand marg'"
mycursor.execute(sql)
mydb.commit()
print(mycursor.rowcount, "record(s) deleted")
```


---

Original Source: https://www.mindstick.com/forum/34595/database-activities-in-python

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.