Soldato
- Joined
- 24 Nov 2002
- Posts
- 16,378
- Location
- 38.744281°N 104.846806°W
I have a simple mysql table, for example:
And another table,
I naturally want to normalise this. Is there an intrinsic way to do this with sql (join?)? As I'm using php queries to do it at the moment.
Code:
Book Genre
Veg is cool 1, 3, 4
And another table,
Code:
Genre Def
1 Factual
2 Fiction
3 Recipe book
4 New
5 Used
I naturally want to normalise this. Is there an intrinsic way to do this with sql (join?)? As I'm using php queries to do it at the moment.