[Help] My Pet Query -_-

[pretzel666]

Ok i have no clue what im doing wrong can someone help me?
Query Before Entering it

insert into cq_itemtype (id,name,monopoly,price,id_action,dodge,amount,amo unt_limit,gem1,hitrate,monster_type,able_mask,exp_ type,emoney,official1,official2,official3,official 4,official5)
values
('815156', 'Azurai', '28', '3000000', '9544445', '0000', '1', '1', '00', '00000', '815156', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1082160', 'Azurai', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1072160', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072160', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072161', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072161', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072162', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072162', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076160', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076160', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076161', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076161', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076162', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076162', '7', '1', '00', '11', '21', '31', '41', '51');

Then After i enter it in console i get this
Error in console

mysql> insert into cq_itemtype (id,name,monopoly,price,id_action,dodge,amount,amo unt_limit,gem1,hitrate,monster_type,able_mask,exp_ type,emoney,official1,official2,official3,official 4,official5)
values
('815156', 'Azurai', '28', '3000000', '9544445', '0000', '1', '1', '00', '00000', '815156', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1082160', 'Azurai', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1072160', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072160', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072161', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072161', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072162', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072162', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076160', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076160', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076161', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076161', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076162', 'Azurai', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076162', '7', '1', '00', '11', '21', '31', '41', '51');
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '4,official5)
values
('815156', 'Azurai', '28', '3000000', '95
mysql>

# Nvm , fixed , was a space in the wrong spot XD

[SoulNecturn]

read what error message is telling you ....

your query starts:

insert into cq_itemtype (id,name,monopoly,price,id_action,dodge,amount,amo unt_limit,gem1,hitrate,monster_type,able_mask,exp_ type,emoney,official1,official2,official3,official 4,official5)
values

the red one is wrong

why? You made space between official and 4 (you cant do things like that)

fix it to official4 = without space

and really just read error messages as its more then clearly showing you where and what is wrong....