Python Database API ( Application Program Interface ) is the Database interface for the standard Python. This standard is adhered to by most Python Database interfaces. There are various Database servers supported by Python Database such as MySQL, GadFly, mSQL, PostgreSQL, Microsoft SQL Server 2000, Informix, Interbase, Oracle, Sybase etc. To connect with MySQL database server from Python, we need to import the mysql.connector interface.
Syntax:
CREATE DATABASE DATABASE_NAME
Example:
# importing rquired libraries import mysql.connector dataBase = mysql.connector.connect( host ="localhost", user ="user", passwd ="gfg") # preparing a cursor object cursorObject = dataBase.cursor() # creating database cursorObject.execute("CREATE DATABASE geeks4geeks") |
Output:
The above program illustrates the creation of MySQL database geeks4geeks in which host-name is localhost, the username is user and password is gfg.
Let’s suppose we want to create a table in the database, then we need to connect to a database. Below is a program to create a table in the geeks4geeks database which was created in the above program.
# importing required library import mysql.connector # connecting to the database dataBase = mysql.connector.connect( host = "localhost", user = "user", passwd = "gfg", database = "geeks4geeks" ) # preparing a cursor object cursorObject = dataBase.cursor() # creating table studentRecord = """CREATE TABLE STUDENT ( NAME VARCHAR(20) NOT NULL, BRANCH VARCHAR(50), ROLL INT NOT NULL, SECTION VARCHAR(5), AGE INT, )""" # table created cursorObject.execute(studentRecord) # disconnecting from server dataBase.close() |
Output:
Recommended Posts:
- Create MySQL Database Login Page in Python using Tkinter
- Connect MySQL database using MySQL-Connector Python
- Python: MySQL Create Table
- Create a database in MongoDB using Python
- Python MySQL - Where Clause
- Python MySQL - Join
- MySQL-Connector-Python module in Python
- Python MySQL - Limit Clause
- Python MySQL - Select Query
- Python MySQL - Order By Clause
- Python MySQL - Drop Table
- Python MySQL - Update Query
- Python MySQL - Insert into Table
- Python MySQL - Delete Query
- How to install MySQL connector package in Python?
- Oracle Database Connection in Python
- Python - Database Manager (dbm) package
- Python | Database management in PostgreSQL
- Unicodedata – Unicode Database in Python
- Inserting variables to database table using Python
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.
