Database activities in Python

Anonymous User 1430 09 Jul 2018

how to Create, delete, select, insert, ordered by activities of SQL in Python ?

Ask by Anonymous User

Updated 09 Jul 2018

1 Answers

Prakash nidhi Verma 09 Jul 2018

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")

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

Database activities in Python

Can you answer this question?

1 Answers