-SQL—语法常见的抛错

抛错

列的数量和值得数量不符

SQL 错误 [1136] [21S01]: Column count doesn't match value count at row 1
  SQL 错误 [1136] [21S01]: Column count doesn't match value count at row 1
    SQL 错误 [1136] [21S01]: Column count doesn't match value count at row 1
      SQL 错误 [1136] [21S01]: Column count doesn't match value count at row 1
        Column count doesn't match value count at row 1
        Column 10 count doesn't match value count 9 at row 1

一旦加约束表示只能是唯一值，不能重复 ，此抛错为：1的数据有多条

SQL 错误 [1062] [23000]: Duplicate entry ‘1’ for key ‘studentinfo_un’
Duplicate entry ‘1’ for key ‘studentinfo_un’
Duplicate entry ‘1’ for key ‘studentinfo_un’

字段和名称并没有一个默认的值

SQL 错误 [1364] [HY000]: Field ‘name’ doesn’t have a default value
SQL 错误 [1364] [HY000]: Field ‘name’ doesn’t have a default value
SQL 错误 [1364] [HY000]: Field ‘name’ doesn’t have a default value
SQL 错误 [1364] [HY000]: Field ‘name’ doesn’t have a default value
Field ‘name’ doesn’t have a default value
Field ‘name’ doesn’t have a default value