oops...I'm wrong...you can load that way. -----Original Message----- From: Rick Emery Sent: Monday, November 12, 2001 12:56 PM To: [EMAIL PROTECTED] Subject: RE: load_file problem
Are you trying to load the contents of a file with an INSERT statement? If so, you can't. The values MUST be constants. What are your really trying to do? -----Original Message----- From: Venugopal Allavatam [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 12:26 PM To: Sinisa Milivojevic Cc: [EMAIL PROTECTED] Subject: load_file problem Hi! I am stuck with the load_file problem... I have created the following table : create table table_name (field_number1 int unsigned primary key not null, data_field longblob not null); I then tried to load the contents of a file with permissions -rw-r--r-- located in the /home/user directory on my Red Hat 7.1 version of linux using the following statements... insert into table_name values (1, load_file('/home/user/file_name')); or insert into table_name values (1, load_file("/home/user/file_name")); (both produce the same result) it gives me an error that a null cannot be stored as I set it that way in the table creation statement. It also means that the load_file function is returning a null. I am using the 3.23.36 of mysql. I need suggestions. Thank you Venu ===== ============================================================ Venugopal Allavatam Ph: (res.): 949-361-6604 1100 Calle Del Cerro, (mobile): 949-842-1767 Apt.# 123-J, San Clemente, CA-92672 E-mail: [EMAIL PROTECTED] [EMAIL PROTECTED] ============================================================ __________________________________________________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
