FiveTech Software tech support forums

con esto lo resolvi

SELECT ma_arti,ma_desc FROM exi_suc INTO OUTFILE 'c:/archivos/lista.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

gracias Armando

saludos

... Syntax: xCC [options] srcfile{.C|.ASM} Options: /D<name>[=<text>] Define a preprocessor symbol /E Preprocess only (to stdout) /Fo<outfile> Name the output file /Gd Use __cdecl as default calling convention (default) /Gh Enable hook function call /Gm Don't decorate __stdcall ...

... guarda las estructuras,,, pero es mucho mas rápido que mysqldump)... pero,,, solo backupeas y las restauras desde tu aplicación,,,, SELECT * INTO OUTFILE //copias/productos FROM tabprod ORDER BY código // copia la data de la tabla tabprod a un archivo plano productos LOAD DATA INFILE //copias/productos ...

Hola.... Estas sentencias sirven para exportat e importar data tipo txt SELECT * INTO OUTFILE //copias/productos FROM tabprod ORDER BY código // copia la data de la tabla tabprod a un archivo plano productos LOAD DATA INFILE //copias/productos INTO TABLE tabprod // ...

... of this utility. I have tried to use it this way: sxstrace.exe Trace -logfile:MySxSTrace.log my.exe sxstrace.exe Parse -logfile:MySxSTrace.log -outfile:MySxSTrace.txt but MySysTrace.txt is empty. Could you please explain us how to use it ? many thanks :-)

Thanks for the reply, but the problem is that I can't change this, because it's a CSV-file created by an SQL-command.
I can't find how how to change the format in MySQL in an 'INTO OUTFILE' command.
So I need to solve this with Harbour..

Regards,
Marc

Pablo Uso TMySql willy probando, si hago esto: SELECT * INTO OUTFILE "tabla1.txt" FROM tabla1 si funciona y deja el archivo en el data de mysql perooo si quiero poner el archivo a otra ruta SELECT * INTO OUTFILE "D:/respaldo/tabla1.txt" ...

... of control from the DLL back to the CallDLL( ) function. retval := I2PDF_AddImage(alltrim( infile ) ) // processed ok retval := I2PDF_MakePDF( outfile, 0, @cBuffer , 300 ) // processed ok - created the .PDF file, but control never returned back to my program. Here is what was on the screen ...

Dear Mr.Willi, Thanks. SELECT * INTO OUTFILE 'e:\BACKUPS\productos.txt' FROM productos and LOAD DATA INFILE 'e:\BACKUPS\productos.txt' INTO TABLE productos The problem that I understand with the above command is that it will generate only the ...

Hi,,,
SELECT * INTO OUTFILE 'e:\BACKUPS\productos.txt' FROM productos
and
LOAD DATA INFILE 'e:\BACKUPS\productos.txt' INTO TABLE productos
is available only on the PC with MySQL Server

Regards
Willi

Hello,,,
I use this command for backup....
SELECT * INTO OUTFILE 'e:\BACKUPS\productos.txt' FROM productos

for restore....
LOAD DATA INFILE 'e:\BACKUPS\productos.txt' INTO TABLE productos

Regards
Willi

PD (my English is bad,,, sorry)

Holas, si se le asigna la usuario el priviliegio >"files", se puede usar la siguiente orden

"SELECT * INTO OUTFILE '/BACKS/listado.txt' FROM listado"

donde listado.txt contendra la infoirmacion de la tabla listado en formato txt plano...

Salu2