# How to read a file and insert it into a mysl blob field

**URL:** <https://www.ruby-forum.com/t/how-to-read-a-file-and-insert-it-into-a-mysl-blob-field/121165>\
**Category:** Ruby\
**Created:** [November 24, 2007, 6:46pm UTC](https://www.ruby-forum.com/t/how-to-read-a-file-and-insert-it-into-a-mysl-blob-field/121165 "2007-11-24T18:46:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jawosis](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/f04885/32.png) [@jawosis](https://www.ruby-forum.com/u/jawosis)\
**Post date:** [November 24, 2007, 6:46pm UTC](https://www.ruby-forum.com/t/how-to-read-a-file-and-insert-it-into-a-mysl-blob-field/121165/1 "2007-11-24T18:46:47Z")

</div>

How can I read a localy stored file and insert it into a mysal blob  
field?

Thanx

---

<div class="post-metadata">

**Author:** ![jawosis](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/f04885/32.png) [@jawosis](https://www.ruby-forum.com/u/jawosis)\
**Post date:** [November 24, 2007, 9:04pm UTC](https://www.ruby-forum.com/t/how-to-read-a-file-and-insert-it-into-a-mysl-blob-field/121165/2 "2007-11-24T21:04:02Z")

</div>

Jochen K. wrote:

> How can I read a localy stored file and insert it into a mysal blob  
> field?

require ‘mysql’

begin  
dbh = Mysql.real\_connect(‘localhost’, ‘username’, ‘passwd’,  
‘database’)

data = File.read(‘data.txt’) #get the data out of the file  
data = dbh.escape\_string(data) #escape any quotes in the data

dbh.query("  
INSERT INTO table\_name (char\_field, int\_field, tinyblob\_field)  
VALUES  
(‘apple’, 3, ‘#{data}’)  
")

result = dbh.query(“SELECT \* FROM table\_name”)  
while row = result.fetch\_row do  
printf “%s, %s, %s\n”, row[0], row[1], row[2]  
end

result.free

rescue Mysql::Error =\> e  
puts “Error code: #{e.errno}”  
puts “Error message: #{e.error}”  
puts “Error SQLSTATE: #{e.sqlstate}” if e.respond\_to?(‘sqlstate’)  
ensure  
dbh.close if dbh  
end

---

<div class="post-metadata">

**Author:** ![jawosis](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/f04885/32.png) [@jawosis](https://www.ruby-forum.com/u/jawosis)\
**Post date:** [November 25, 2007, 2:08am UTC](https://www.ruby-forum.com/t/how-to-read-a-file-and-insert-it-into-a-mysl-blob-field/121165/3 "2007-11-25T02:08:13Z")

</div>

7stud – wrote:

> Jochen K. wrote:
> 
> > How can I read a localy stored file and insert it into a mysal blob  
> > field?

Just to be clear:

1. I am assuming ‘mysl’ and ‘mysal’ should be ‘mysql’.

2. The field names char\_field, int\_field, tinyblob\_field in the  
following code:

dbh.query("  
INSERT INTO table\_name (char\_field, int\_field, tinyblob\_field)  
VALUES  
(‘apple’, 3, ‘#{data}’)  
")

have no significance–those names should be whatever you named your  
fields in your database, e.g. name, id, data.