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