How do you create temporary MySQL table in SQLAlchemy?

I want to create a customer database for 36500 entry (row) in one table in mysql ?

• i want to create a database for customer who buy a item a shop individual. but in a day 100 customer can buy a item. so in a day there will 100 entrys individual, in a year 36500 ...show more

• Answer:

  I'm not quite understanding your problem. A MySQL table can hold millions (and billions) of rows. You can have up to 4,096 columns. You can easily store 36,500 rows without any performance degradation. You can store millions of rows with little to no performance degradation if you setup proper indexes. Now, after 365 days you can delete the old rows, but there's really no point in doing so since the size would be so small. It would be better to archive those rows to another table or another database.