Re[2]: Help! (LONGTEXT)
At 3:35 AM +0300 5/23/01, Olexandr Vynnychenko wrote: >Hello Paul, > >Wednesday, May 23, 2001, 3:24:29 AM, you wrote: > >PD> At 3:22 AM +0300 5/23/01, Olexandr Vynnychenko wrote: >>>Hello mysql, >>> >>>Can anybody tell me what should I do? I use LONGTEXT column in my >>>table to store data files (html, for example). But I see that I >>>cannot simply >>>INSERT INTO table SET longtext_column=whole_file. But I must do it >>>today. But >>>how??? > >PD> The LOAD_FILE() function might help you if you have the files on the >PD> server host and you have the FILE privilege. > >>> >>>Thanks beforehand. >>> >>>-- >>>Best regards, >>> Olexandr Vynnychenko >>>mailto:[EMAIL PROTECTED] > > > >But if the file is local? Then you're going to have to write a script and construct the INSERT statement with the contents of the file properly encoded in the query string. > >-- >Best regards, > Olexandrmailto:[EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] - 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
Re[2]: Help! (LONGTEXT)
Hello Paul, Wednesday, May 23, 2001, 3:24:29 AM, you wrote: PD> At 3:22 AM +0300 5/23/01, Olexandr Vynnychenko wrote: >>Hello mysql, >> >>Can anybody tell me what should I do? I use LONGTEXT column in my >>table to store data files (html, for example). But I see that I cannot simply >>INSERT INTO table SET longtext_column=whole_file. But I must do it today. But >>how??? PD> The LOAD_FILE() function might help you if you have the files on the PD> server host and you have the FILE privilege. >> >>Thanks beforehand. >> >>-- >>Best regards, >> Olexandr Vynnychenko mailto:[EMAIL PROTECTED] But if the file is local? -- Best regards, Olexandrmailto:[EMAIL PROTECTED] - 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
Re: Help! (LONGTEXT)
At 3:22 AM +0300 5/23/01, Olexandr Vynnychenko wrote: >Hello mysql, > >Can anybody tell me what should I do? I use LONGTEXT column in my >table to store data files (html, for example). But I see that I cannot simply >INSERT INTO table SET longtext_column=whole_file. But I must do it today. But >how??? The LOAD_FILE() function might help you if you have the files on the server host and you have the FILE privilege. > >Thanks beforehand. > >-- >Best regards, > Olexandr Vynnychenko mailto:[EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] - 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
Help! (LONGTEXT)
Hello mysql, Can anybody tell me what should I do? I use LONGTEXT column in my table to store data files (html, for example). But I see that I cannot simply INSERT INTO table SET longtext_column=whole_file. But I must do it today. But how??? Thanks beforehand. -- Best regards, Olexandr Vynnychenko mailto:[EMAIL PROTECTED] - 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