### Navigation

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

# pandas.io.sql.write_frame

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

  DEPRECATED - use to_sql

  Write records stored in a DataFrame to a SQL database.

  Parameters : | frame : DataFrame name : string con : DBAPI2 connection flavor : {‘sqlite’, ‘mysql’}, default ‘sqlite’ The flavor of SQL to use. 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. index : boolean, default False Write DataFrame index as a column

  See also

  `pandas.DataFrame.to_sql`

  Notes

  This function is deprecated in favor of `to_sql`. There are however two differences:

  - With `to_sql` the index is written to the sql database by default. To keep the behaviour this function you need to specify `index=False`.
  - The new `to_sql` function supports sqlalchemy engines to work with different sql flavors.

### Navigation

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