Subtables in MySQL
Posted: Sun Aug 29, 2004 8:21 am
Is there any way to create sub-tables for each row in MySQL.
Like FirstName,MiddleName,LastName table for a field named Name in main table.
Something like this ?
Like FirstName,MiddleName,LastName table for a field named Name in main table.
Code: Select all
`Main tbl`
|-Id
|-Roll
|-Name
| |-First
| |-Middle
| |-Last
|-Address
|-Phone