Welcome Guest ( Log In | Register)



 
 Reply to this topicStart new topic
> Loading File Into Blob Fields To Mysql
eskimmer
post Aug 17 2007, 02:41 PM
Post #1


Newbie [Level 1]
*

Group: Members
Posts: 21
Joined: 15-August 07
Member No.: 48,203
Hi all!

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

(list)

Go to the top of the page
 
+Quote Post
Trap FeedBacker
post Jan 14 2008, 05:51 AM
Post #2


Guest Feedbacks
***************

Group: Members
Posts: 2,360
Joined: 21-September 07
Member No.: 50,369
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

(list)

Go to the top of the page
 
+Quote Post
« Next Oldest · Database · Next Newest »
 

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Installing Mysql On Unix, Linux(2)
  2. Mysql And Sql(7)
  3. You Can Inport Big File Sql With Bigdump(0)
  4. Mysql(7)
  5. Mysql Datatype Int() Question(1)
  6. Question Regarding File Transfer!(3)
  7. Database With Mysql++(4)
  8. Mysql Query Problems(6)
  9. Mysql-essential-5.0.51 Installion Problem(1)
  10. The Best Free Php Mysql Blog(5)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 13th May 2008 - 09:51 PM
Powered By IP.Board © 2008  IPS, Inc.
Licensed to: Xisto Corporation