#pymysql

[simplexianpo]

Python3.x : Operation database - pymysql

First, you need to download a module:

 pip3 install PyMySQL

 Next is the code:

  #!/usr/bin/python

# -*- coding: UTF-8 -*-

import pymysql

localhost = "xxxxxxxx" # Your database address

username = "xxxxxxxx" # Your username

password = "xxxxxxxx" # Your password

database = "xxxxxxxx" # Your database instance

db = pymysql.connect(localhost, username, password, database, charset="utf8") # Pay attention to coding

cursor = db.cursor()

cursor.execute("select * from account") # Try to query the sql statement

cursor.nextset()

data = cursor.fetchone()

print(data)

cursor.nextset()

data = cursor.fetchone()

print(data)

  data_all = cursor.fetchall() # Get all the data

[simplexianpo]

Python : Query all tables and fields of mysql - pymysql demo

#!/usr/bin/python

# -*- coding: UTF-8 -*-

import pymysql

# Query all fields

def list_col(localhost, username, password, database, tabls_name):

   db = pymysql.connect(localhost, username, password, database, charset="utf8")

   cursor = db.cursor()

   cursor.execute("select * from %s" % tabls_name)

   col_name_list = [tuple[0] for tuple in cursor.description]

   db.close()

   return col_name_list

# List all tables

def list_table(localhost, username, password, database):

   db = pymysql.connect(localhost, username, password, database, charset="utf8")

   cursor = db.cursor()

   cursor.execute("show tables")

   table_list = [tuple[0] for tuple in cursor.fetchall()]

   db.close()

   return table_list

username = "root" # User name

password = "root" # Connection password

localhost = "localhost" # chained address

database = "school" # Database name

tables = list_table(localhost, username, password, database) # Get all tables and return an iterable object

print(tables)

for table in tables:

   col_names = list_col(localhost, username, password, database, table)

   print(col_names) # Output all field names

[mattparko]

Connect to OpenStack MariaDB using PyMySQL

Connect to OpenStack MariaDB using PyMySQL

Many of OpenStack’s containerised services do not include a MySQL client, despite heavily relying on the MariaDB/Galera cluster. Instead, the services use the PyMySQL and SQLAlchemy python modules for this interaction.

Given that peeking into the database is a pretty common operation when troubleshooting issues in OpenStack, the lack of a MySQL client is a bit of a pain point. Yes, you can always…

View On WordPress

[gatelockservice]

How to retrieve the ID after a MySQL Insert in Python-pymysql

How to retrieve the ID after a MySQL Insert in Python-pymysql

When you have an auto_incrementfield on a table, and you’re doing a batch import of new data, you often want to insert a row, then insert more rows that have a foreign key referencing the first row. For example, you want to insert a COMPANY entity, then insert a few dozen PERSON entities under that company. Assuming you have no unique and not-null fields on the COMPANY entity (if company_name…

View On WordPress

[arkylus]

How to retrieve the ID after a MySQL Insert in Python-pymysql

How to retrieve the ID after a MySQL Insert in Python-pymysql

When you have an auto_incrementfield on a table, and you’re doing a batch import of new data, you often want to insert a row, then insert more rows that have a foreign key referencing the first row. For example, you want to insert a COMPANY entity, then insert a few dozen PERSON entities under that company. Assuming you have no unique and not-null fields on the COMPANY entity (if company_name…

View On WordPress