@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