Thanks
This is exactly what I needed
Olaf
On 5/11/09 7:15 AM, "Janek Bogucki" wrote:
> Hi Olaf,
>
> If you only need to compress the column *while* loading it from the csv file
> then use load data infile with a user variable to do the compression at load
> time,.
>
> mysql> create table t(u
Hi Olaf,
If you only need to compress the column *while* loading it from the csv file
then use load data infile with a user variable to do the compression at load
time,.
mysql> create table t(uncompressed varchar(4000), compressed varbinary(1000));
Query OK, 0 rows affected (0.07 sec)
mysql> \
hi Olaf,
in unix you have small programms that do one thing and not more.
What you want to archive is a compressed output files.
the most easy way is:
| gzip -c >outfile
depending on your data replace gzip with zoo,lha,bzip2,compress,.
re,
wh
Olaf Stein schrieb:
> Or even better, can I
Or even better, can I tell load data infile or somewhere in the table
definition to compress whatever is written to the file?
Thanks
Olaf
On 5/8/09 12:29 PM, "Olaf Stein" wrote:
> Hi all
>
> What is the equivalent in unix (more specifically python) to the compress()
> function.
>
> I am tryi
Hi all
What is the equivalent in unix (more specifically python) to the compress()
function.
I am trying to make csv file for use with load data infile and am wondering
how to compress the strings that I would usually compress with compress() in
a regular sql statement. The field I am writing thi