Hello world.

SQL将查询结果插入到现有表中:

      Insert into USER_B (ad_user_id,Value,name,manager_id)

  Select ad_user_id,Value,name,manager_id from USER_A Where( manager_id =100001)

 

SQL重置数据表(清除表内所有数据,ID重新记数)

  truncate table tablename

posted on 2010-05-02 11:11  Ryan.zhu  阅读(284)  评论(0编辑  收藏  举报
come soon on