摘要:
select * from A where StudentId in ( SELECT StudentId FROM A WHERE CheckTime > '2020-12-22' AND CheckState = 'extractfail' GROUP BY StudentId,Author,T 阅读全文
摘要:
mysqldump -uroot -p123456 -h 127.0.0.1 --default-character-set=utf8 databasename tablename--where=" left (CourseReourceCode,4)='MSJT' and RIGHT (Cours 阅读全文
摘要:
c = a >b? a:b if a>b: c = a else: c = b 用表达式 c = a if a>b else b #注意这里的c 不能用 函数 只能用变量 如: 写成变量就会正常 二维列表: c = [b,a][a>b] 还有for 循环的 用list解析的 [对(x)的操作 for 阅读全文
摘要:
SELECT fileid FROM files WHERE description LIKE '%%%s%%' OR filename LIKE '%%%s%%' OR uploader LIKE '%%%s%%' ORDER BY fileid DESC" % (search, search, 阅读全文