Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

[RESUELTO] insert into

Started by root , Jan 11 2011 11:50 AM

Please log in to reply

1 reply to this topic

#1 root

mister

Miembro Platino
529 posts

LocationMexico D.F:

Posted 11 January 2011 - 11:50 AM

saludos
se puede hacer eso

sql

SET @contador = 5 ;
INSERT INTO base (base.paterno, base.materno, base.nombre)
VALUES( SELECT concat('"',ap_paterno,'" ,"', ap_materno,'" ,"', nombre,'"') 
FROM pn25 WHERE row_id = @contador )

digo le asigno el valor a la variable, okya cheke el select y si, los valkores salen como deveria de
pero no los inserta

0

Back to top

#2 root

mister

Miembro Platino
529 posts

LocationMexico D.F:

Posted 11 January 2011 - 01:10 PM

ya me ayudaron

ps si era casi casi logico

si son parametros hay que pasarlos como parametros

la forma correcta es

sql

INSERT INTO base (base.paterno, base.materno, base.nombre, base.calle, base.ext, base.inter, base.colonia, base.municipio, base.cp)
SELECT ap_paterno,ap_materno,nombre,calle,num_ext,num_int,colonia,municipio,cp 
FROM pn25 WHERE row_id = @contador;

0

Back to top

Back to MySQL

[RESUELTO] insert into

#1 root

#2 root

Sign In