Breaking News: Grepper is joining You.com. Read the official announcement!

create database python

Add Answer

JoeyTatu answered on April 20, 2022 Popularity 9/10 Helpfulness 3/10

answer create database python

related how to create a database in python

related create a database in python

create database python

Comment

# Create the Database and Tables (Example data):

import sqlite3

conn = sqlite3.connect('test_database') 
c = conn.cursor()
                   
c.execute('''
          INSERT INTO products (product_id, product_name)

                VALUES
                (1,'Computer'),
                (2,'Printer'),
                (3,'Tablet'),
                (4,'Desk'),
                (5,'Chair')
          ''')

c.execute('''
          INSERT INTO prices (product_id, price)

                VALUES
                (1,800),
                (2,200),
                (3,300),
                (4,450),
                (5,150)
          ''')

conn.commit()

## ## ## ## ## ## ## ## ## 

# Display the results:

import sqlite3
import pandas as pd

conn = sqlite3.connect('test_database') 
c = conn.cursor()
                   
c.execute('''
          SELECT
          a.product_name,
          b.price
          FROM products a
          LEFT JOIN prices b ON a.product_id = b.product_id
          ''')

df = pd.DataFrame(c.fetchall(), columns=['product_name','price'])
print (df)

Popularity 9/10 Helpfulness 3/10 Language python

Source: datatofish.com

Tags: database python

Link to this answer
Share Copy Link

Contributed on Apr 20 2022

JoeyTatu

0 Answers Avg Quality 2/10

Closely Related Answers

how to create a database in python

Comment

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword"
)

mycursor = mydb.cursor()

mycursor.execute("CREATE DATABASE mydatabase")

Popularity 10/10 Helpfulness 5/10 Language python

Source: Grepper

Tags: database databas

Link to this answer
Share Copy Link

Contributed on Apr 26 2022

Zac

0 Answers Avg Quality 2/10

create a database in python

Comment

# Here is a sample from https://www.w3schools.com/python/python_mysql_create_db.asp 

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword"
)

mycursor = mydb.cursor()

mycursor.execute("CREATE DATABASE mydatabase")

Popularity 10/10 Helpfulness 3/10 Language python

Source: Grepper

Tags: database databas

Link to this answer
Share Copy Link

Contributed on May 28 2022

CompSciGeek

0 Answers Avg Quality 2/10

create database python

Contents

More Related Answers

create database python

Closely Related Answers

how to create a database in python

create a database in python

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.