说明:复制表(只复制结构,源表名:a新表名:b)select*intobfromawhere1<>1说明:拷贝表(拷贝数据,源表名:a目标表名:b)insertintob(a,b,c)selectd,e,ffromb;说明:显示文章、提交人和最后回复时间selecta.title,a.username,b.adddatefromtablea,(selectmax(adddate)add... Read More
posted @ 2010-05-07 14:34 LARSON _ Views(261) Comments(0) Diggs(1) Edit