If you actually get binary data loaded into your table, DO NOT run a select * from table command.. It will stream out all the data and it's not pretty..
instead run a select col1, col2, length(binarycol) .. On Tue, 22 Jul 2003, Steven Wu wrote: > Hi Jeremy D. Zawodny: > I did not get any error message. It hust said "zero column change" and > the filed, VIDEO contains NULL data after I give "SELECT * from GAME" > command. > > Steven Wu > ----- Original Message ----- > From: "Jeremy Zawodny" <[EMAIL PROTECTED]> > To: "Steven Wu" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, July 22, 2003 12:12 PM > Subject: Re: store video file into MySQL database server > > > > On Tue, Jul 22, 2003 at 12:03:44PM -0700, Steven Wu wrote: > > > Hi Need emergency help: > > > > > > I am doing some project use the MySQL to store the video file. The > > > format of video is either avi or mpg. However I can not successfully > > > insert the video file into the cooresponding field of a table by > > > using the "LOAD_FILE" function. > > > > Could you tell us what error message MySQL gives you? > > -- > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > > MySQL 4.0.13: up 12 days, processed 369,853,118 queries (335/sec. avg) > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]