List:General Discussion« Previous MessageNext Message »
From:Sean L. Gilley Date:September 15 1999 1:56pm
Subject:load_file questions..
View as plain text  
I'm trying to use the load_file() function and not getting anywhere.
Everything I try gives me a syntax error.  Am I doing something wrong,
or does this version my MySQL not support the load_file() function?

Here's my insert line:

  update attachments set attachment=load_file("/home/slg/mr_req.PDF") where num='811'

The error:

  ERROR 1064: You have an error in your SQL syntax near '("/home/slg/mr_req.PDF") where
num='811';' at line 1


Here's the table definition:

  mysql> describe attachments;
  +------------+-------------+------+-----+---------+-------+
  | Field      | Type        | Null | Key | Default | Extra |
  +------------+-------------+------+-----+---------+-------+
  | num        | int(11)     | YES  |     | NULL    |       |
  | title      | varchar(50) | YES  |     | NULL    |       |
  | attachment | blob        | YES  |     | NULL    |       |
  +------------+-------------+------+-----+---------+-------+
  3 rows in set (0.00 sec)

Here's my version:

  mysqladmin  Ver 7.11 Distrib 3.22.23b, for hp-hpux10.20 on hppa1.1


Thanks,

Sean.

---
Sean L. Gilley            Word of the day:
slg@stripped    blellum: a lazy, talkative person
Thread
load_file questions..Sean L. Gilley15 Sep
  • Re: load_file questions..James Manning15 Sep
    • Re: load_file questions..Paul DuBois15 Sep