Jump to content

error 1064 (ayuda con query)


Recommended Posts

podrian ayudarme con esta query 


 INSERT INTO `shop_item` VALUES (75, 14020, 1,);
la tabla del navicat esta asi
del  - shop_vnum  - item_vnum  -  count  - name
[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 ')' at line 1
alguien sabe porque me sale esto ? y podria ayudarme porfavor
Link to comment
Share on other sites

le falta el nombre despues del ultimo campo, por eso te da error


 INSERT INTO `shop_item` VALUES (75, 14020, 1,'nombre');[/color]


[color=rgb(90,90,90);font-family:tahoma, helvetica, arial, sans-serif;font-size:12px;background-color:rgb(253,253,253);]sino quieres poner nombre deberias hacerlo asi:[/color]


[sql] INSERT INTO `shop_item` (shop_vnum, item_vnum, count) VALUES (75, 14020, 1);


o asi:


[color=rgb(90,90,90);font-family:tahoma, helvetica, arial, sans-serif;font-size:12px;background-color:rgb(253,253,253);][sql] INSERT INTO `shop_item` VALUES (75, 14020, 1,'');  Nota: Las comillas finales son dos comillas simples[/color]
Link to comment
Share on other sites

  • Dilong locked this topic
This topic is now closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...