[数据库] 清空纪录问题

sql = "delete * from [06级自动化聘课表] where 学期='" & text1.text & "'"
rst.Open sql, cn, adOpenDynamic, adLockPessimistic
运行时提示： “*”附近语法错误
请问怎么回事啊