Jul 26, 2008

Loading File Into Blob Fields To Mysql
Free Web Hosting, No Ads > CONTRIBUTE > Computers > Database

free web hosting

Loading File Into Blob Fields To Mysql

eskimmer
Aug 17 2007, 02:41 PM
Hi all!

does any know how to load file into blob filed by sql script?

Reply

iGuest
Jan 14 2008, 05:51 AM
Saving a resultset into file
Loading File Into Blob Fields To Mysql

Hi,
I am newbee to Mysql, so not much aware of the syntax.
I want to copy the resultset of a table into a file like

SELECT * INTO OUTFILE 'data.Txt'
FIELDS TERMINATED BY ','
FROM ...

But my problem is that the query will be used in a stored procedure and the filename and delimiter will be passed during runtime.

Please provide any solution if possible.

-question by Sourendra

Reply


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Recent Queries:-
  1. mysql load sql from file - 1.11 hr back. (1)
  2. mysql blob java pdf file into database - 7.93 hr back. (1)
  3. vb.net mysql blob picture load - 12.80 hr back. (1)
  4. sql file blob mysql - 20.76 hr back. (1)
  5. "
  6. saving blob in mysql with java - 30.51 hr back. (1)
  7. load sql file into mysql with php - 31.43 hr back. (1)
  8. blob load tool - 35.99 hr back. (1)
  9. saving blob to file mysql stored procedure - 37.51 hr back. (1)
  10. mysql blob load java - 41.34 hr back. (1)
  11. insert and retrieve blob fields from mysql using php - 47.07 hr back. (1)
  12. load image mysql command sql blob - 52.45 hr back. (2)
  13. php blob video file - 54.08 hr back. (1)
  14. mysql loading blobs - 55.75 hr back. (1)
Similar Topics

Keywords : loading, file, blob, fields, mysql

  1. The Best Free Php Mysql Blog
    any idea (5)
  2. Mysql-essential-5.0.51 Installion Problem
    please help me.(urgent) (2)
    Dear friend, please help me. Iam working on php project (matchmaking site). I have downloaded mysql
    essensial 5.0.51. When i was installing mysql 5.0.51, i got following error - Error 1901: Error
    attempting to read from the source installation database:
    c:\windows\installer\527ec6.msi What is solution of this problem ? Iam using
    windows xp professional version 2002 (service pack 2). Please post your reply. Iam waiting for your
    answer. ....
  3. Mysql Query Problems
    I need some help or a tutorial? (6)
    I seem to be having trouble with getting my Query to post my user's ID numbers. CODE //
    Make a MySQL Connection mysql_connect("localhost", "user",
    "password") or die(mysql_error());
    mysql_select_db("databasename") or die(mysql_error()); // Retrieve
    all the data from the members table $result = mysql_query("SELECT * FROM members WHERE
    id='$id'") or die(mysql_error());   // store the record of the
    id table into $row $row = m....
  4. Database With Mysql++
    getting mySQL++ to work with trap17 (7)
    Hi, I'm trying to build an online game and figured the easiest way to do the server list would
    be to make a mySQL database for it; however, I use the con() command on the IP i get from pinging my
    website and I always get an abnormal program termination; however, it will work with the mySQL on my
    own machine. The code is below: CODE #include <iostream> #include <iomanip>
    #include <mysql++> #include "pass.h"//holds my password (i program at
    school) int main(void) {     Connection con("t3jem3_test","....
  5. Question Regarding File Transfer!
    FILE TRANSFER (4)
    Hi friends, I am looking for a secure and robust file transfer web service. I am handling a sales
    force which is stationed at different locations and is frequently moving. They need to upload there
    activity reports frequently to our servers. So I am looking for an easy to use secure and robust
    file transfer web service which can be used by my sales force for their needs. Thanks & Warm
    Regards. ....
  6. Mysql Datatype Int() Question
    Not sure what value to use inside int() (1)
    Can anyone clarify what the value in int() actually does? CREATE TABLE job_class ( jc_id int(1)
    NOT NULL AUTO_INCREMENT PRIMARY KEY, jc_index int(2) NOT NULL, jc_name varchar(20) NOT NULL, jc_type
    varchar(20) NOT NULL ); I was under the impression that any integer value used inside a () was
    the limit that data-type would have. In the PRIMARY KEY column I was able to add integer values
    1-18. I'm kinda confused now If I can add 2 digit integers there then what is the point of
    assigning values inside brackets() For the varchar() any number put in there does limit....
  7. Mysql
    (7)
    Hi... One of my hosts hasnīt MySQL but i need to develop a login system so I need to know if itīs
    possible to use a MySQL database intalled in another host... If itīs possible can you explain me how
    to do it? Thanks in advance....
  8. You Can Inport Big File Sql With Bigdump
    (0)
    You Can Inport Big File SQL With Bigdump And You Can Find This File With Google
    !!!!! If You Can Get It Please PM :tranvantrung_thao >>>>>OK ....
  9. Mysql And Sql
    difference??? (7)
    I was wondering what is the difference between MySQL and SQL. I was really confused when i planned
    to do a project recently. This question has haunted me for a long time. Is it both same?....
  10. Mysql Database Copying
    (4)
    Is there anyway to merge 2 databases? I have an XOOPS and SMF both installed with Fantastico, and
    the bridge is not working like the Joomla! one does. (with the seperate db capability) i know
    how to transfer all the tables by hand but depending on how much data you have stored in mysql could
    take a long time. Take short time!? Help me!....
  11. Installing Mysql On Unix, Linux
    (2)
    Download the latest version of MySQL.Choose the latest stable release and, from the stable release
    page, choose the option under "Source Downloads" marked "tarball (.tar.gz)". Download the file into
    a directory where files can be created and there is sufficient disk space. A good location is /tmp.
    Change directory to this location using: 1. % cd /tmp Note that the % character
    should not be typed in; this represents the Linux shell prompt and indicates that the command should
    be entered at the shell prompt. 2. Uncompress the package in the new ....
  12. Mysql Tools Database
    Opensource sql tools... (1)
    You can download mysql query web browser on http://www.mysql.com you also can download plugin
    there...like conector mysql from visual basic ,java,etc with my sql query tool browser you can make
    and maintance youre database sql easily because use gUI interface..!!....


      13. Looking for loading, file, blob, fields, mysql

Searching Video's for loading, file, blob, fields, mysql
advertisement



Loading File Into Blob Fields To Mysql



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!" 		Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE