有两张表:表 Word 和 表Temp. 要将表Temp中所有记录的Vocabulary和Explanation插入到Word中的新建记录,并且每行记录的CourseID值= i.请问如何实现?
sql = "INSERT into Words (Vocabulary, Explanation,CourseID ) values ( Select Vocabulary,Explanation From Temp,'" + i + "')";
cmd = new SQLiteCommand(sql);
cmd.Connection = cn;
cmd.ExecuteNonQuery();
sql = "INSERT into Words (Vocabulary, Explanation,CourseID ) values ( Select Vocabulary,Explanation From Temp,'" + i + "')";
cmd = new SQLiteCommand(sql);
cmd.Connection = cn;
cmd.ExecuteNonQuery();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货