如何将表中的数据复制到另一个表中？ [英] How do I copy data from table into another table?

问题描述

我需要的是一个学生自己注册，在注册期间，他可以申请具有各自细节的科目数。我创建了stud_Table，Subject_Table和Temp_Subject_Table。在注册科目选择时，他们的详细信息存储在Temp_Subject_Table中。用户点击注册然后我使用

What i am needing is a student register himself and during registration he can apply for number of subjects with their own individual details.I have created stud_Table, Subject_Table and Temp_Subject_Table.During registration subjects opted an their details are stored in Temp_Subject_Table.When user click on register then i copied the subjects into Subject_Table using

"INSERT INTO Subject_Table SELECT * FROM Temp_Subject_Table"

...但是没有工作？

有没有人有更好的方法来实现这个目标......

感谢提前.......

...but not working?
Is anyone having better way of achieving this...
Thank's in advance.......

推荐答案

请访问此链接：使用INSERT和SELECT添加行 [ ^ ]



你应该指定列的列表，数据类型应该相等。

Please, visit this link: Adding Rows by Using INSERT and SELECT[^]

You should specify the list of columns and the data types should be equal.

这篇关于如何将表中的数据复制到另一个表中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！