SQLite Forum

Placeholder for table name when inserting data?
Login
Hi TripeHound, you are making good point about the books, will keep this in mind, thank you.

My data are financial stock prices. So database is say stocks.db and then I have one table for each stock price. Schema is the same for each table, date is UNIQUE, the rest are 5 columns of numbers, open, hi, low, close and volume. This would be example with lots of tables, it probably can't be structured any other way?

Or, another example are some economic numbers I'm scraping on a weekly basis. Again, first column, date is UNIQUE, this prevents double entries. Then I have some 10+ columns of numbers. Here tables have a different schema, since number of columns vary from table to table.