Pandas version checks

  • [X] I have checked that the issue still exists on the latest versions of the docs on main here

Location of the documentation

pandas.to_sql

Documentation problem

to_sql 能否增加 数据的 INSERT IGNORE INTO， 遇到重复数据自动忽略。 另外就是to_sql 遇到有主键的表格，无法写入数据

Suggested fix for documentation

1、 to_sql 增加 INSERT IGNORE INTO ，遇到重复数据自动忽略，不影响其他数据写入 2、to_sql 遇到有主键的表格无法写入 3、to_sql 能否根据 自动增加 SQL表格字段

Comment From: MarcoGorelli

hi @majormj could you ask in english please?

Comment From: MarcoGorelli

closing for now as I can't tell what you're asking, sorry

Comment From: majormj

Pandas.to_sql has the following issues

1、Unable to successfully write data when MySQL table has primary key

2、Can you add write methods for "updata" and "Insert IGNORE" so that when writing to a MySQL data table with a primary key, it can successfully overwrite the updated data or incrementally write the data

3、When the fields in the data table do not exist in the MySQL table, can the corresponding fields be automatically added to the MySQL table and the data be written to the MySQL table

Comment From: MarcoGorelli

could you open a new issue and fill in the issue template please?

Comment From: majormj

ok