### Navigation

- index
- modules |
- next |
- previous |
- pandas 0.13.1 documentation »
- API Reference »

# pandas.io.sql.write_frame

`pandas.io.sql.``write_frame`(frame, name, con, flavor='sqlite', if_exists='fail', **kwargs)

  Write records stored in a DataFrame to a SQL database.

  Parameters : | frame: DataFrame name: name of SQL table con: an open SQL database connection object flavor: {‘sqlite’, ‘mysql’, ‘oracle’}, default ‘sqlite’ if_exists: {‘fail’, ‘replace’, ‘append’}, default ‘fail’ fail: If table exists, do nothing. replace: If table exists, drop it, recreate it, and insert data. append: If table exists, insert data. Create if does not exist.

### Navigation

- index
- modules |
- next |
- previous |
- pandas 0.13.1 documentation »
- API Reference »