To select from a table in MySQL, use the “SELECT” statement.
import mysql.connectormydb = mysql.connector.connect( host=“localhost”, user=“yourusername“, password=“yourpassword”, database=“mydatabase”)mycursor = mydb.cursor()mycursor.execute(“SELECT * FROM customers”) myresult =...
To create a MySQL table in Python, use the "CREATE TABLE" statement.
Make sure you define the name of the database when you create the connection.
import mysql.connector mydb = mysql.connector.connect( host="localhost", user="yourusername", password="yourpassword", database="mydatabase" ) mycursor = mydb.cursor() mycursor.execute("CREATE TABLE customers (name VARCHAR(255), address...
To create a database in MySQL, use the "CREATE DATABASE" statement:
Below is the example of Creating a MySQL Database in Python:
import mysql.connector mydb = mysql.connector.connect( host="localhost", user="yourusername", password="yourpassword" ) mycursor = mydb.cursor() mycursor.execute("CREATE DATABASE mydatabase")
If the above code was executed with no errors, It means your database has...
Below is the example code of how to connect MySQL database with Python.
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword"
)
print(mydb)
Use the username and password from your MySQL database:
MySQL Database
To experiment with the code examples in this page, you should have MySQL installed on your computer.
To download a free MySQL database at https://www.mysql.com/downloads/.
Install MySQL Driver
Python needs a MySQL driver to access the MySQL database.
We recommend that you use PIP to install "MySQL Connector".
PIP is most likely already installed in your Python environment....
English
French
Spanish
Portuguese
Deutsch
Turkish
Dutch
Italiano
Russian
Romaian
Portuguese (Brazil)
Greek
