s="""
| ANSWERS |
| ANSWER_EVALUATIONS |
| BULLETINS |
| BULLETIN_RECEIVERS |
| CHAT_LOGS |
| COLLECTION_QUESTIONS |
| COMMON_NEWSES |
| COMMON_NEWS_CHANNELS |
| COURSES |
| CURRENT_STUDY_NODES |
| CUSTOMIZE_NEWS_CHANNELS |
| EVALUATION_MEMBER |
| EVALUATION_MSG |
| EVALUATION_TASK |
| EXERCISES |
| EXERCISE_RECEIVERS |
| EXERCISE_STRATEGY |
| EXERCISE_STUDENTS |
| EXPERIMENT |
| EXPERIMENT_COURSES |
| FORUMS |
| FORUM_CATEGORIES |
| FORUM_POSTS |
| FORUM_TOPICS |
| FORUM_TOPIC_TO_USER |
| FORUM_TO_USER |
| FRIEND_GROUPS |
| FRIEND_LINKS |
| GRADES |
| GRADE_COURSE |
| GROUP_TO_ROLE |
| HOMEWORK_RECORD |
| KNOWLEDGE_DOCUMENT |
| KNOWLEDGE_NODES |
| LEARNING_RESOURCE |
| LEARNING_RESOURCE_TO_NODE |
| LEARNING_RES_TO_RECOMMEND_RES |
| LOW_PRACTICE_RECORD |
| MASTER |
| MESSAGES |
| MESSAGE_RECEIVERS |
| MESSAGE_STATISTICS |
| PAPER |
| PAPER_ANSWER_JUDGE |
| PAPER_ANSWER_JUDGE_ITEM |
| PAPER_ARRANGEMENT |
| PAPER_STRATEGY |
| PAPER_STRATEGY_ITEM |
| PERSONAL_NOTE |
| PRACTICES |
| PRAXIS_ANSWER_STATISTICS |
| PRAXIS_CONTENT |
| PRAXIS_PAPER |
| PRAXIS_REVIEW |
| PRAXIS_STAT |
| QUESTIONS |
| QUESTION_EVALUATIONS |
| QUESTION_LIBRARIES |
| RECENT_CONTACTS |
| RECOMMEND_RECEIVERS |
| RECOMMEND_RESOURCES |
| RECOMMEND_RES_TO_RES |
| ROLE_TO_RESOURCE |
| SCHEDULINGS |
| SCHEDULING_RECEIVERS |
| SCHOOLS |
| SITE_VISIT_STATES |
| SUP_QUES_OF_PAPER |
| SYSTEM_CONFIGS |
| SYSTEM_LOGS |
| SYSTEM_RESOURCES |
| TASK_ARRANGES |
| TASK_PRACTICE_RECORD |
| TASK_RECEIVERS |
| TC_MA_VERSIONS |
| TEACH_RESOURCES |
| TEACH_RESOURCES_CACHE |
| TEACH_RESOURCES_COMMENTS |
| TEACH_RESOURCES_RECOMMEND |
| TEACH_RESOURCES_TO_USERS_ACCEPT |
| TEACH_RESOURCES_TO_USERS_ACCEPT_GROUP |
| TEACH_RESOURCES_TO_USERS_STORE |
| TEXTBOOK_ARRANGES |
| TINY_QUES_OF_PAPER |
| UPLOAD_FILES |
| USERS |
| USER_GROUPS |
| USER_ROLES |
| USER_TO_FRIEND_GROUP |
| USER_TO_GROUP |
| USER_TO_ROLE |
| VICE_ADMIN_USER_TO_GROUP |
| VOD_RECORDS |
| VOTE_OPTIONS |
| VOTE_QUESTIONS |
| WORK |
"""
sql=""
for t in s.split('|'):
t = t.strip()
if t == '':
pass
else:
if t=='USERS':
sql += "DELETE FROM "+t+" WHERE ACCOUNT!='admin';"
elif t in ('USER_TO_ROLE','USER_ROLES'):
pass
else:
sql += "DELETE FROM "+t+";"
fd=open(r'c:\delete.sql','w')
fd.write(sql)
fd.close()
print sql
清空数据库的表
最新推荐文章于 2024-03-05 15:41:08 发布