Python Pandas to_sql, how to create a table with a primary key?

by

Simply add the primary key after uploading the table with pandas.

group_export.to_sql(con=engine, name=example_table, if_exists="replace", 
                    flavor="mysql", index=False)

with engine.connect() as con:
    con.execute('ALTER TABLE `example_table` ADD PRIMARY KEY (`ID_column`);')

More Related Contents:

  1. How to convert SQL Query result to PANDAS Data Structure?
  2. How to insert pandas dataframe via mysqldb into database?
  3. How to replace Django’s primary key with a different integer that is unique for that table
  4. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  5. Python Pandas write to sql with NaN values
  6. Split / Explode a column of dictionaries into separate columns with pandas
  7. How to split a dataframe string column into two columns?
  8. Comparing two dataframes and getting the differences [duplicate]
  9. plot different color for different categorical levels using matplotlib
  10. Python: best practice and securest way to connect to MySQL and execute queries
  11. Get the name of a pandas DataFrame
  12. Pandas Dataframe: Replacing NaN with row average
  13. How to read a .xlsx file using the pandas Library in iPython?
  14. SQLAlchemy ON DUPLICATE KEY UPDATE
  15. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  16. Pandas Groupby / List to Multiple Rows
  17. How to reorder indexed rows based on a list in Pandas data frame
  18. Mapping ranges of values in pandas dataframe [duplicate]
  19. Pandas can’t read hdf5 file created with h5py
  20. Plotting a stacked Bar Chart
  21. Get first row value of a given column
  22. Convert month int to month name in Pandas
  23. How to plot percentage with seaborn distplot / histplot / displot
  24. Week of a month pandas
  25. MemoryError when I merge two Pandas data frames
  26. Warning raised by inserting 4-byte unicode to mysql
  27. Merging two tables with millions of rows in Python
  28. Selecting a range of columns in a dataframe
  29. Pandas data frame to dictionary of lists
  30. Pandas min() of selected row and columns

Leave a Comment