CODEWITHSUNDEEP
phpmysqlsqlstructure
Mathew Bateman
Mathew Bateman

Reputation: 3

SQL Weekly Results Table Structure

I was wondering if anyone could help me get my head around this problem that I'm having, I have an Excel spreadsheet with the following layout.

Area |ID   |Location  |Week1 |Week2 |Week3+
71   |1484 |Rochdale  |713   |728   |690
71   |1485 |Doncaster |713   |728   |690

How would I best structure an SQL table to store these, that I could then easily retrieve and display in html?

Any help would be greatly appreciated.

Upvotes: 0

Views: 45

Answers (1)

Strawberry
Strawberry

Reputation: 33945

At its most basic:

Area|ID |Location |Week |Value

Further optimisation might be required

Upvotes: 1

Related Questions