SergioT Posted April 23, 2014 Report Share Posted April 23, 2014 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 More sharing options...
Yori Posted April 23, 2014 Report Share Posted April 23, 2014 el item 14020 tiene nombre?? Link to comment Share on other sites More sharing options...
SergioT Posted April 24, 2014 Author Report Share Posted April 24, 2014 si obiamente Link to comment Share on other sites More sharing options...
Desmint Posted April 24, 2014 Report Share Posted April 24, 2014 El Querry Ya Es Existente, Cambia El Numero Por Otro Y Insertalo De Nuevo SergioT 1 Link to comment Share on other sites More sharing options...
SergioT Posted April 24, 2014 Author Report Share Posted April 24, 2014 si? osea quiero llenar tiendas con esa query Link to comment Share on other sites More sharing options...
Yori Posted April 24, 2014 Report Share Posted April 24, 2014 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] Shogun 1 Link to comment Share on other sites More sharing options...
pepineitor Posted April 24, 2014 Report Share Posted April 24, 2014 INSERT INTO `shop_item` VALUES (75, 14020, 1); El error te sale porque después del 1 ponías una ',' y la tabla en la que intentas meter los datos tiene 3 columnas en lugar de 4. Shogun 1 Link to comment Share on other sites More sharing options...
SergioT Posted April 25, 2014 Author Report Share Posted April 25, 2014 la tabla tiene 5 columnas estas del - shop_vnum - item_vnum - count - name Link to comment Share on other sites More sharing options...
Shogun Posted April 25, 2014 Report Share Posted April 25, 2014 Te aconsejo que te leas algun tutorial básico de MySQL. Link to comment Share on other sites More sharing options...
Recommended Posts