Jump to content

error 1064 (ayuda con query)


SergioT
 Share

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
Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

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