起风了

步骤：导入包写sql语句编写引擎：engine=sqlalchemy.create_engine('mysql+pymysql://root:123@localhost:3306/db1')root是用户名，123是密码，@是本地地址，3306是端口，db1是库名读取是pd.read_sql(sql,engine,)写入是to_sql('mydf2',engine,index=Fal...

部分数据内容如下：括号划分优先级：找出上海本科的职位信息和北京硕士的职位信息select * from DataAnalystwhere (city = '上海' and education= '本科') or (city = '北京' and education = '硕士')去重计数：找出每个城市的职位数select city,count(distinct posit...

补充：