1、1136 - Column count doesn’t match value count at row 1

    列和值的数量 不匹配

    2、1054 - Unknown column ‘11年级’ in ‘field list’

    原因1:没有这个列,原因2:值没有引号

    3、1062 - Duplicate entry ‘1’ for key ‘PRIMARY’

    主键有重复的值

    4、[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’年级表’ values (12,12)’ at line 2

    语法错了

    5、[Err] 1366 - Incorrect integer value: ‘sdfaf’ for column ‘年级编号’ at row 1

    整数列的值不是整数

    6、[Err] 1364 - Field ‘年级编号’ doesn’t have a default value

    列没有默认值,列不为空

    7、[Err] 1292 - Incorrect date value: ‘1951’ for column ‘出生日期’ at row 1

    日期没有引号

    8、[Err] 1452 - Cannot add or update a child row: a foreign key constraint fails (xuexiao.学生表, CONSTRAINT 学生表_ibfk_1 FOREIGN KEY (所在年级) REFERENCES 年级表 (年级编号))

    外键错了

    9、[Err] 1146 - Table ‘bf.成绩表’ doesn’t exist

    找不到表,表名写错或数据库选错