On 26 Aug 2002, at 15:32, Donald J Miller wrote: > CREATE TABLE filetest(fileid int(5) not null, file BLOB null); > > I 've created the table and have used LOAD DATA in order to populate the > database however I get numerous errors. Can someone shed some light as > to how to do this correctly? What would be the proper query to retrieve > this file out of mysql?
You're not giving us much to go on. How exactly did you use "LOAD DATA"? How did you escape the data? What do the "numerous errors" say? Retrieving the data works the same as retrieving any other data from MySQL: you use "SELECT column_name FROM ...". -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- 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
