Shulou(Shulou.com)06/01 Report--

This article mainly introduces "how to create and connect the database". In the daily operation, I believe that many people have doubts about how to create and connect the database. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubts about "how to create and connect a database"! Next, please follow the editor to study!

Create a database connection

You can use the following code to connect to the database:

Demo_mysql_test.py:

Import mysql.connector

Mydb = mysql.connector.connect (

Host= "localhost", # database host address

User= "yourusername", # database user name

Passwd= "yourpassword" # Database password

)

Print (mydb)

Create a database

To create a database using the "CREATE DATABASE" statement, create a database named runoob_db:

Demo_mysql_test.py:

Import mysql.connector

Mydb = mysql.connector.connect (

Host= "localhost"

User= "root"

Passwd= "123456"

)

Mycursor = mydb.cursor ()

Mycursor.execute ("CREATE DATABASE runoob_db")

We can also use the "SHOW DATABASES" statement to see if the database exists before creating the database:

Demo_mysql_test.py:

Output a list of all databases:

Import mysql.connector

Mydb = mysql.connector.connect (

Host= "localhost"

User= "root", p

Asswd= "123456"

)

Mycursor = mydb.cursor ()

Mycursor.execute ("SHOW DATABASES")

For x in mycursor:

Print (x)

Or we can connect to the database directly and output an error message if the database does not exist:

Demo_mysql_test.py:

Import mysql.connector

Mydb = mysql.connector.connect (

Host= "localhost"

User= "root"

Passwd= "123456"

Database= "runoob_db"

)

At this point, the study on "how to create and connect to a database" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.