21 lines
583 B
Batchfile
21 lines
583 B
Batchfile
|
@echo off
|
||
|
|
chcp 65001 >nul
|
||
|
|
echo ========================================
|
||
|
|
echo 验证考核题目数据
|
||
|
|
echo ========================================
|
||
|
|
echo.
|
||
|
|
|
||
|
|
echo 正在查询题目数量...
|
||
|
|
echo.
|
||
|
|
|
||
|
|
mysql -u root -p123456 peidu -e "SELECT level, COUNT(*) as total, SUM(CASE WHEN deleted = 0 THEN 1 ELSE 0 END) as active FROM exam_question GROUP BY level;"
|
||
|
|
|
||
|
|
echo.
|
||
|
|
echo 正在查询题目列表...
|
||
|
|
echo.
|
||
|
|
|
||
|
|
mysql -u root -p123456 peidu -e "SELECT id, level, LEFT(question_content, 40) as question, correct_answer, score FROM exam_question WHERE deleted = 0 ORDER BY level, id;"
|
||
|
|
|
||
|
|
echo.
|
||
|
|
pause
|