MySQL 错误：ER_WRONG_VALUE_COUNT_ON_ROW：列计数与第 1 行的值计数不匹配
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/24773064/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Error: ER_WRONG_VALUE_COUNT_ON_ROW: Column count doesn't match value count at row 1
提问by Kishore Indraganti
INSERT INTO MediaTrackInactive(MediaTrackInactiveID, PrimaryCategoryID, Title, Source, AnchorName, ProducedBy, CoverageID, Content, AudioLength, IsLead, CreationTime, UploadTime, StoryTypeID, IsPending)
VALUES(103257 , '10', 'How does the US make the case for its interests in Ukraine?', 'NewsHour, PBS NewsHour, News', '1', 'Reporting from the Aspen Ideas Festival in Colorado, Hari Sreenivasan interviews the former American Ambassador to Russia, Michael McFaul, in a conversation focused on the crisis in Ukraine and its impact on U.S.-Russian relations.', '365', '', 1404602224000, 1404689273287, 2, 0)
While trying to execute the above query the following error is coming Error: ER_WRONG_VALUE_COUNT_ON_ROW: Column count doesn't match value count at row 1I really don't understand what I'm doing wrong Thanks
在尝试执行上述查询时，出现以下错误 错误：ER_WRONG_VALUE_COUNT_ON_ROW：列计数与第 1 行的值计数不匹配我真的不明白我做错了什么谢谢
回答by Prateek Mishra
You are providing less values than you have mentioned.
您提供的价值比您提到的要少。
You have mentioned 14 column names and you are providing values for only 12 columns.
您提到了 14 个列名，并且您只提供了 12 个列的值。
回答by Jens
You have specified more columns than values. I guess some 'is missing.
您指定的列数多于值。我想有些'遗漏了。
Maybe here: 'PBS NewsHour, PBS NewsHour, Rivet',
也许在这里： 'PBS NewsHour, PBS NewsHour, Rivet',
