mysql插入错误字段_mysql插入数据不成功，核对字段及类型了，无误，怎么回事? id为AUTO_INCREMENT...

最新推荐文章于 2022-06-29 16:17:51 发布

能睡

最新推荐文章于 2022-06-29 16:17:51 发布

阅读量202

点赞数

本文链接：https://blog.csdn.net/weixin_36446697/article/details/113951729

版权

mysql插入错误字段

展开全部

|这表结构字段属性设计的很糟糕，建议修改！

mysql> create table publish (number int(8),user varchar(20),name varchar(20),phone int(12),title text,content text ,list int(1),things varchar(20),quality varchar(20),glance int(5),trad varchar(20),classify varchar(6),city_id int(6),exchange varchar(6),town_id int(5),town varchar(20),ex_he varchar(20),my_ex varchar(50),photo int(2),ip int(12),time int(10)) ;

Query OK, 0 rows affected (0.02 sec)mysql> insert into publish (number,user,name,phone,title,content,list,things,quality,glance,trad,classify,city_id,exchange,town_id,town,ex_he,my_ex,photo,ip,time) values (1,'2','3',4,'5','6',7,'8','9',10,'11','12',13,'14',15,'16','17','18',19,20,21);

Query OK, 1 row affected (0.01 sec)mysql> select * from publish;

+--------+------+------+-------+-------+---------+------+--------+---------+--------+------+----------+---------+----------+---------+------+-------+-------+-------+------+------+

+--------+------+------+-------+-------+---------+------+--------+---------+--------+------+----------+---------+----------+---------+------+-------+-------+-------+------+------+

| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |

+--------+------+------+-------+-------+---------+------+--------+---------+--------+------+----------+---------+----------+---------+------+-------+-------+-------+------+------+

1 row in set (0.00 sec)