gpt4 book ai didi

mysql - 错误 1136 (21S01) : Column count doesn't match value count but am giving same number of values with same data type

转载 作者:行者123 更新时间:2023-11-29 16:04:25 25 4
gpt4 key购买 nike

我插入的值与具有正确数据类型的列数相同,但仍然显示列数不匹配。

All the columns are here in this link

插入map_city值 -> ('IN',744101,'海洋码头','安达曼和尼科巴群岛','南安达曼','波特布莱尔',11.6667,92.75,3,132,51,57,5,163,55,2770,4.76534296,2.057761733, 5.884476534,61.92561093,8.605560944,763.0978608);错误 1136 (21S01):列计数与第 1 行的值计数不匹配

我也尝试过,双引号但仍然不起作用。

最佳答案

尝试将值插入到与其字段相关的列中,例如

INSERT INTO map_city (country_code, pin_code, place_name, ) VALUES ('IN',744101,'marine jetty');

关于mysql - 错误 1136 (21S01) : Column count doesn't match value count but am giving same number of values with same data type,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/55874198/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com