您当前的位置:天天ASP学习数据库ACCESS → 文章内容

临时表的使用

作者:本站  来源:本站整理  发布时间:2018-03-22 18:59:50
'clear
conn.execute("drop table xuanboy")

'bulid table
conn.execute("SELECT x.* INTO [xuanboy] FROM (select id,sname,yue,ri,ctai from xiaokao where ctai=0 order by time_ord asc) x")
conn.execute("INSERT INTO [xuanboy] SELECT x.* FROM (select id,sname,yue,ri,ctai from xiaokao where ctai=1 order by time_ord desc) x")
文章评论 (评论内容只代表网友观点,与本站立场无关!)