Organization of tables/rows in mysql

[bgold12]

Hey, I'm kind of new to mysql, and I'm not sure which is a better
method of organizing data. I have 10 chat rooms, and for each room I
want to store 10 messages. Does this mean I should create 10 tables,
one for each chat room, and have each of the 10 messages as one row
entry in the chat room table? Or should I create one main table that
stores all 100 messages as 100 row entries, and identify for each
message which chat room it belongs to? Or is there a different way I
should be managing this?

Thanks,

bgold12

[Captain Paralytic]

On 3 Sep, 16:03, bgold12 <[e-mail]:

Hey, I'm kind of new to mysql, and I'm not sure which is a better
method of organizing data. I have 10 chat rooms, and for each room I
want to store 10 messages. Does this mean I should create 10 tables,
one for each chat room, and have each of the 10 messages as one row
entry in the chat room table? Or should I create one main table that
stores all 100 messages as 100 row entries, and identify for each
message which chat room it belongs to? Or is there a different way I
should be managing this?

Thanks,

bgold12

The latter.

[Captain Paralytic]

On 3 Sep, 16:03, bgold12 <[e-mail]:

Hey, I'm kind of new to mysql, and I'm not sure which is a better
method of organizing data. I have 10 chat rooms, and for each room I
want to store 10 messages. Does this mean I should create 10 tables,
one for each chat room, and have each of the 10 messages as one row
entry in the chat room table? Or should I create one main table that
stores all 100 messages as 100 row entries, and identify for each
message which chat room it belongs to? Or is there a different way I
should be managing this?

Thanks,

bgold12

Also, this should be asked in comp.databases.mysql

[Roger]

On Sep 3, 9:03*am, bgold12 <[e-mail]:

Hey, I'm kind of new to mysql, and I'm not sure which is a better
method of organizing data. I have 10 chat rooms, and for each room I
want to store 10 messages. Does this mean I should create 10 tables,
one for each chat room, and have each of the 10 messages as one row
entry in the chat room table? Or should I create one main table that
stores all 100 messages as 100 row entries, and identify for each
message which chat room it belongs to? Or is there a different way I
should be managing this?

Thanks,

bgold12

create a table called tblChatRoom
chatRoomId autonumber (pk)
chatRoom varchar

create a table called tblMessage
messageId autonumber (pk)
chatRoomId int (fk)
message varchar
this will allow many chatrooms, and many messages