如何将pandas中的以下代码重写为sql？

import pandas as pd
import pymysql

# 连接到MySQL数据库
conn = pymysql.connect(host='localhost', user='root', password='password', database='mydatabase')
cursor = conn.cursor()

# 创建表
create_table_query = '''
CREATE TABLE mytable (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT,
    city VARCHAR(50)
)
'''
cursor.execute(create_table_query)

# 将DataFrame数据插入表中
data = {'id': [1, 2, 3],
        'name': ['Alice', 'Bob', 'Charlie'],
        'age': [25, 30, 35],
        'city': ['New York', 'London', 'Paris']}
df = pd.DataFrame(data)

for index, row in df.iterrows():
    insert_query = f"INSERT INTO mytable (id, name, age, city) VALUES ({row['id']}, '{row['name']}', {row['age']}, '{row['city']}')"
    cursor.execute(insert_query)

# 使用SQL查询语句替代pandas数据操作
select_query = "SELECT * FROM mytable WHERE age > 30"
cursor.execute(select_query)
result = cursor.fetchall()

# 打印查询结果
for row in result:
    print(row)

# 关闭数据库连接
conn.close()