Create a lot of tables?

Question

I will like to create lots tables in a database.
The tables will have same structure and be named as
2001-01-01
2001-01-02
......
2016-12-31

May you suggest some code to doing that?

Answer 1

If you still need it not in the way Yc Gu said then build up the code at excel or notepad or something. You'll have to copy and paste and then you run it at the developer tool.

Answer 2

Suggest put them in one table, just add a column which shows the dates

Answer 3

My data source records stock history trading data listed by days. There are 500000+ rows in each day. Totally there are about 20GB to deal with.
I wish at front end users can load certain data in a very short time(0.2s I wish). I am not familiar with efficiency of MySQL. So I just think in common sense that if i can separate them to many tables, it won't have to deal with 20GB in each query.

Is my consider right or not?
Maybe there are some suggestions to deal with large data?

Answer 4

@Heck Robin, you should consider migrating to another database provider, such as PostgreSQL, SQL server ir Oracle.