db.close() # 이전에 연결된 데이터베이스 끊어주세요 (에러나면 이미 끊어진 것임)
host_name = "0.0.0.0"
username = "root"
password = "korea123"
database_name = "customer" # 데이터베이스 이름을 sakila 로 바꿔줘야 합니다.
db = pymysql.connect(
host=host_name, # DATABASE_HOST
port=3306,
user=username, # DATABASE_USERNAME
passwd=password, # DATABASE_PASSWORD
db=database_name, # DATABASE_NAME
charset='utf8'
)
df = pd.read_sql("SHOW TABLES;", db)
df
df = pd.read_sql("SELECT * FROM customer_table", db)
df
df = pd.read_sql("SELECT * FROM order_table", db)
df
df = pd.read_sql("SELECT * FROM customer_table C INNER JOIN order_table O ON C.customer_id = O.customer_id", db)
df
df = pd.read_sql("SELECT * FROM customer_table, order_table WHERE customer_table.customer_id = order_table.customer_id", db)
df
df = pd.read_sql("SELECT C.customer_name FROM customer_table C INNER JOIN order_table O ON C.customer_id = O.customer_id", db)
df
df = pd.read_sql("SELECT * FROM customer_table C JOIN order_table O ON C.customer_id = O.customer_id", db)
df
df = pd.read_sql("SELECT * FROM customer_table C LEFT OUTER JOIN order_table O ON C.customer_id = O.customer_id", db)
df
SQL = """
SELECT *
FROM customer_table C
LEFT OUTER JOIN order_table O ON C.customer_id = O.customer_id
WHERE O.order_id IS NULL
"""
df = pd.read_sql(SQL, db)
df
SQL = """
SELECT * FROM order_table O
LEFT OUTER JOIN customer_table C
ON C.customer_id = O.customer_id
"""
df = pd.read_sql(SQL, db)
df
df = pd.read_sql("SELECT * FROM customer_table C RIGHT OUTER JOIN order_table O ON C.customer_id = O.customer_id", db)
df
df = pd.read_sql("SELECT * FROM customer_table C RIGHT JOIN order_table O ON C.customer_id = O.customer_id", db)
df