I have 2 tables.

Table 1 have few fields and including (email, firstName, lastName, etc ... )

Table 2 have few fields and including (email, name).

I want to write a query which selects all data from table 1 and insert id, email, name (concat firstname + lastname) and insert it in table 2 appropriate columns.

any idea ?

Yes, i have

If you attach the original assignment and supply your teacher's email address we should be able to improve the turnaround speed of your homework and get fewer errors.

Mike

lolz .. well it's not an ASSIGNMENT. i am really working on some project and it's been quite a long that i have done any DB thingy. since most of the time i was working on C/C++/Delphi (creating system level things) and now after long time i have been moved to JAVA (Enterprise Application). so .. that's why i am seeking help from you people, if you people do.

Is there any reason why you want to concatenate first and last names into a single field? Take my word for it when I tell you that you'll be wanting to split them back up again real soon

Must admit I can't see why you want to duplicate data that you have stored in one table into another table but if you have a good reason to then simply write the select statement that will return all the field values that you want to insert into the new table. To create a unique id you'll need to investigate auto_increment fields. Finally turn the select statement into an insert statement.

Seeing as you've been using MySQL for over 2 years now it may well be worth investing in a cheap book on MySQL and doing a little reading

Mike

ok guys thanks for the help. i successfully wrote the query that i was looking for. i am writing here so that if someone is seeking help for such kinda query - then this post might help him