[Help] My Pet Query -_-

11/09/2012 05:32 pretzel666#1
Ok i have no clue what im doing wrong can someone help me?
Query Before Entering it
Quote:
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
Quote:
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
11/09/2012 16:13 SoulNecturn#2
read what error message is telling you ....

your query starts:
Quote:
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....