Adding multiple entries to one column in one row?
Moderator: General Moderators
Adding multiple entries to one column in one row?
I am wondering is it possible to add multiple entries to one column in one row? If so, how can this be done? Thanks in advance.
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Usually you would do this with a second table, such as:
Code: Select all
parent_table
id name
1 car
2 motorcycle
child_table
id parent_id name
1 1 Audi
2 1 Skoda
3 2 Kawasaki
4 2 Ducati(#10850)
- Kieran Huggins
- DevNet Master
- Posts: 3635
- Joined: Wed Dec 06, 2006 4:14 pm
- Location: Toronto, Canada
- Contact:
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
. I'd go with the join.