MySQL beginner confused!

[ventspacey]

Alright, I am a definate nube at mysql and I have a problem that I just cannot figure out. I am trying to integrate a CMS database 'forum' data to another CMS database forum. I pretty much have all the variable lined up, I just need to do one thing...
Alright, say I have a two table example1 and example 2
I need to migrate the data from example 2 table to example 1 table but I need to match the data up alongside the data that currently resides there. Like for instance in table example1 I have a primary key there and I just need the example2 table to group data accordingly with the primary key in example 1 table, which is an auto_increment field.
I am not really sure that I completely understand if I even explained that right, but I hope someone can just help me out a little bit here. This is my first task ever working with MySQL and I feel like I may be over my head... But there is no greater lesson than experience.

[mwasif]

Hi ventspacey,

Welcome to TSDN!!!

You can use INSERT...SELECT syntax of MySQL. You can choose the data to INSERT in SELECT statement on any criteria you want.

[ventspacey]

okay, well let me give you an example...
table 1 includes these columns.

id, name, email

table 2 includes these columns

mesid
message

I need to somehow migrate table 2 into table 1 but I need the messages to correspond to the names...

[Delerna]

Diagrams of your data and result you want can help when asking a question of this type. For example

Table1
id, name, email
1 Ted Ted@Emailaddress
2 Ken Ken@EmailAddress

table2 -- Note mesid relates to id
mesid message
2 Hello from ken
2 Another hello from ken
1 Hello from Ted
2 A third hello from ken

Result --Note This should be a view
ID Name Email message
2 Ken Ted@Emailaddress Hello from ken
2 Ken Ted@Emailaddress Another hello from ken
2 Ken Ted@Emailaddress A third hello from ken
1 Ted Ken@EmailAddress Hello from Ted

Is something like that what you are after???

By the way, its good to do that with any problem you are struggling with.
with a bit of experience the answer can jump out at you


PS Are you in over your head? Yes, at the moment
Will you ever be able to swim?? Yes, if you never give up, never surrender