how to get one column data of a table and it can be put into a column of another table [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.开发者_JAVA技巧 Closed 10 years ago.

how to get one column data of a table and it can be put into a column of another table

plz tell me query

churchill

---

Try this:

INSERT INTO student2 (sname)
SELECT sname FROM student 

---

please see the answer: http://www.webdeveloper.com/forum/showthread.php?t=83585