pythonHow to get data from Mysql
import mysql.connector
connection = mysql.connector.connect(host='localhost', database='db', user='user', password='pwd')
cursor = connection.cursor()
cursor.execute('SELECT * FROM users')
records = cursor.fetchall()ctrl + cimport mysql.connectorlibrary to work with Mysql | mysql.connector.connectconnect to Mysql using specified credentials |
connection.cursor()get cursor object to execute SQL queries | cursor.executerun specified SQL query |
cursor.fetchall()will return all found rows into list | SELECT * FROM usersexample SQL query |
Related
More of Python
- How to get yesterday's date
- How to print a list without brackets
- How to swap two variables values
- How to split string by space
- How to read yaml file
- How to get year from date
- How to use regex
- How to split string by length
- How to get minutes from datetime
- How to zero pad a number
See more codes...