import sqlite3 conn = sqlite3.connect('example.db') c = conn.cursor() c.execute(""" CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT, grade INTEGER ) """) conn.commit() conn.close()
import psycopg2 conn = psycopg2.connect( host="localhost", database="mydb", user="myuser", password="mypassword" ) cur = conn.cursor() cur.execute(""" CREATE TABLE employees ( id SERIAL PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INTEGER ) """) conn.commit() conn.close()
import pymysql conn = pymysql.connect( host="localhost", user="myuser", password="mypassword" ) cur = conn.cursor() cur.execute("CREATE DATABASE mydb") conn.close()This code connects to a MySQL server running on "localhost" with the username "myuser" and password "mypassword". It then creates a new database called "mydb".