Add wings in sql

[アルカード]

I tried to add wings in sql and this is problem i get





Msg 213, Level 16, State 1, Line 5
Column name or number of supplied values does not match table definition.





here is code

 Spoiler

use Arcadia



--All stats +60%
INSERT INTO [ItemResource] VALUES('105326','10105326','20105326','1','110','6 07','21','0','0','0','1','1','0','0','0','1','1',' 1','15','1','1','1','1','0','0','0','0','0.00','1. 00','10','0','0','0','0','3','0','1090553351','216 0000','2','0.00','0','0.00','0.00','0','0.00','0.0 0','0','0.00','0.00','0','0.00','0.00','98','8255. 00','0.70','0','0.00','0.00','0','0.00','0.00','0' ,'0.00','0.00','0','0','0.00','0.00','0.00','0.00' ,'0','0.00','0.00','0.00','0.00','0','0','0','0',' 0','0','0','0','0','0','0','0','0','black_wings_1s t','black_wings_1st','black_wings_1st','black_wing s_1st','black_wings_1st','black_wings_1st','black_ wings_1st','black_wings_1st','black_wings_1st','bl ack_wings_1st','black_wings_1st','black_wings_1st' ,'black_wings_1st','black_wings_1st','black_wings_ 1st','black_wings_1st','black_wings_1st','black_wi ngs_1st','black_wings_1st01','drop_etc_pouch','0', 'bw1','')
INSERT INTO [StringResource] ([name], [group_id], [code], [value]) VALUES (N'name_item_010009','0','105326',N'Sovereign')
INSERT INTO [StringResource] ([name], [group_id], [code], [value]) VALUES (N'name_item_010009','0','10105326',N'Sovereign')
INSERT INTO [StringResource] ([name], [group_id], [code], [value]) VALUES (N'name_itemtooltip_10010','0','20105326',N'@#auto _tooltip#@')

[Xijezu]

The query is build for a different ItemResource structure.

Let's assume I created a table with the following columns:
[id], [name]

I've got the following query:

INSERT INTO test_table VALUES (1, 'test')

This query assumes that there are only 2 columns in my table. The query runs successfully.

Now, assume I've got this query:

INSERT INTO test_table VALUES (1, 'test', 12341234)

If I try to insert this into the same table I had above it can't ant wont work, because there is 1 more value which "has no column".
This is the case in your query.
Your table has less columns than your query you're trying to insert.

You can try to update your query to the new structure, that'd be the only solution.