Re: INSERT DYNAMIC SQL DOESNT GET VALUES
Hi again!, I have the following dynamic sql, which in this moment is printing the column values but no the commas and a lot of space, i've been doing research but I havent found anything right now. Please you could take a look at the following code to improve my code and I can finish my job, which i have spent a lot of time on it. thanks a lot
/*Escribo la consulta donde inserto los datos de manera dinamica*/
SET @consulta_insertar_datos=CONCAT("SELECT 'INSERT IGNORE LOW_PRIORITY INTO
Call_Center_Infinit_",param_id_empresa,".",param_nombre_tabla_respaldar,"(",@columnas_tabla,") VALUES(',",TRIM(CONCAT_WS(',',@columnas_tabla)),"
FROM ",param_nombre_tabla_respaldar,"
INNER JOIN Empresas
ON ",param_nombre_tabla_respaldar,".id=Empresas.",param_nombre_columna,"
WHERE Empresas.id=",param_id_empresa,"
INTO OUTFILE \"/var/lib/mysql/respalda_datos_tbl_",param_nombre_tabla_respaldar,"_",DATE_FORMAT(CURRENT_TIMESTAMP(),'%d%b%Y_%H%i'),".sql\";");
/*Preparo la consulta para su ejecucion*/
PREPARE stmt_consulta_respalda_datos FROM @consulta_insertar_datos;
/*Ejecuto la consulta*/
EXECUTE stmt_consulta_respalda_datos;
/*Borro la sentencia preparada para futuras ejecuciones*/
DEALLOCATE PREPARE stmt_consulta_respalda_datos;