RE: Inserting a file in MySQL

[Jay Blanchard]

[snip]
How do i insert a file in a blob field from the command line ?
[/snip]

>From http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

mysql> UPDATE t
            SET blob_col=LOAD_FILE('/tmp/picture')
            WHERE id=1;

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]