antiblock
https://i.imgur.com/aJ17bf7.gif
  • Chatbox

    Did you check out our Discord? https://discord.gg/FFdvMjk9xA
    You don't have permission to chat.
    Load More
  • 0
Sign in to follow this  
rafaelxte2

Erro De Sql

Question

Alguem poderia me infomar aonde se está o erro nessa sql?

 

SELECT * FROM `shop_item`;
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('23', '50446')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('23', '50447')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('23', '50448')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('23', '50449')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('23', '50450')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50461')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50462')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50463')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50464')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50465')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50466')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50476')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50477')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50478')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50479')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50480')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50481')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50491')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50492')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50493')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50494')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50495')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50496')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50506')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50507')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50508')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50509')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50510')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50511')

 

 

 

me retorna a seguinte mensagem:

 

[Err] 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 'INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('23', '50447')
INSER' at line 2

Share this post


Link to post
Share on other sites

6 answers to this question

  • 0

shop_ite? ou shop_item?

 

 INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('0', '0');  , não sei qual a dificuldade de resolver uma query

agora percebo o erro que me faltou foi o ( ; )  para fechar as linhas 

Perguntaste qual era o erro, eu escrevi a query corretamente.

agora percebo o erro que me faltou foi o ( ; )  para fechar as linhas 

Share this post


Link to post
Share on other sites
antiblock
https://arwen2.global/
  • 0

Insert Into 'shop_item' (shop_vnum, item_vnum) Values ('x', 'y');

Share this post


Link to post
Share on other sites
  • 0

Insert Into 'shop_item' (shop_vnum, item_vnum) Values ('x', 'y');

Desculpe anne mas não entendi

Share this post


Link to post
Share on other sites
  • 0

Perguntaste qual era o erro, eu escrevi a query corretamente.

Share this post


Link to post
Share on other sites
  • 0

ainda me retornas erros

 

 

[Err] 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 ''shop_item' (shop_vnum, item_vnum) Values ('23', '50446')
Insert Into 'shop_ite' at line 1

Share this post


Link to post
Share on other sites
  • 0

shop_ite? ou shop_item?

 

 INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('0', '0');  , não sei qual a dificuldade de resolver uma query

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this