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> \! echo -e 'abcde\nfghijk\n' > /tmp/test.csv
mysql> load data infile '/tmp/test.csv' into table t (@raw) set uncompressed =
@raw, compressed = compress(@raw);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
mysql> select uncompressed, @a:=hex(compress(uncompressed)),
@b:=hex(compressed), @a = @b from t;
+--------------+--------------------------------------+--------------------------------------+---------+
| uncompressed | @a:=hex(compress(uncompressed)) | @b:=hex(compressed)
| @a = @b |
+--------------+--------------------------------------+--------------------------------------+---------+
| abcde | 05000000789C4B4C4A4E49050005C801F0 |
05000000789C4B4C4A4E49050005C801F0 | 1 |
| fghijk | 06000000789C4B4BCFC8CCCA060008870274 |
06000000789C4B4BCFC8CCCA060008870274 | 1 |
| | |
| 1 |
+--------------+--------------------------------------+--------------------------------------+---------+
3 rows in set (0.04 sec)
Cheers,
-Janek
On Fri, 2009-05-08 at 12:29 -0400, Olaf Stein wrote:
> 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 this into is longblob and I
> need the compressed version here to be identical to what compress() would do
>
> Thanks
> olaf
>
> ----------------------------------------- Confidentiality Notice:
> The following mail message, including any attachments, is for the
> sole use of the intended recipient(s) and may contain confidential
> and privileged information. The recipient is responsible to
> maintain the confidentiality of this information and to use the
> information only for authorized purposes. If you are not the
> intended recipient (or authorized to receive information for the
> intended recipient), you are hereby notified that any review, use,
> disclosure, distribution, copying, printing, or action taken in
> reliance on the contents of this e-mail is strictly prohibited. If
> you have received this communication in error, please notify us
> immediately by reply e-mail and destroy all copies of the original
> message. Thank you.
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
