nUnknown column ‘Tabled’ in 'field list 解决
"sql error:/nUnknown column 'Tabled' in 'field list'"
解决:
1)查看表中的字段与插入的字段是否一样
desc 表名
mysql> desc DriverInfo;
+---------------------------+-----------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------------+-----------------+------+-----+---------------------+----------------+
| TableId | bigint unsigned | NO | PRI | NULL | auto_increment |
| DriverName | varchar(128) | NO | | NULL | |
| CompanyId | bigint | NO | MUL | NULL | |
| Sex | int | NO | | NULL | |
| IDcard | varchar(32) | NO | | NULL | |
| IDcardPicturePath | varchar(256) | YES | | NULL | |
| DrivingLicence | varchar(32) | YES | | NULL | |
| DrivingLicencePicturePath | varchar(256) | YES | | NULL | |
| DrivingLicenceBeginTime | timestamp | NO | | 2011-11-11 11:11:11 | |
| DrivingLicenceEndTime | timestamp | NO | | 2011-11-11 11:11:11 | |
| CreateTime | timestamp | NO | | 2011-11-11 11:11:11 | |
| Extern | varchar(1024) | YES | | NULL | |
+---------------------------+-----------------+------+-----+---------------------+----------------+
12 rows in set (0.00 sec)