mysql里句子:
select
i.id,
i.short_code,
i.name,
i.brand,
i.model,
i.manufacturer,
c.registration_number
from items i
left join cfdas c on i.cfda=c.id
where i.name like '%呼吸机%'
Python里读取相同内容:
item1=pd.read_sql(sql="""
select
i.id,
i.short_code,
i.name,
i.brand,
i.model,
i.manufacturer,
c.registration_number
from items i
left join cfdas c on i.cfda=c.id
where i.name like "%%呼吸机%%"
""",con=eng2,index_col=None)
我也不造为什么需要这样,知道的小伙伴能否帮忙科普一下,感谢~~