# Ruby MySQL INSERT variable

**URL:** <https://www.ruby-forum.com/t/ruby-mysql-insert-variable/141944>\
**Category:** Ruby\
**Created:** [July 1, 2008, 11:44pm UTC](https://www.ruby-forum.com/t/ruby-mysql-insert-variable/141944 "2008-07-01T23:44:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jturney](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e99b99/32.png) [@jturney](https://www.ruby-forum.com/u/jturney)\
**Post date:** [July 1, 2008, 11:44pm UTC](https://www.ruby-forum.com/t/ruby-mysql-insert-variable/141944/1 "2008-07-01T23:44:51Z")

</div>

k = “50”

my = Mysql::new(“localhost”, “root”, “pass”, “table”)  
my.query(“INSERT INTO table VALUES(‘2008-05’, #{k}, 324)”)

./Class.rb:212:in `query’: Unknown column ‘50’ in ‘field list’  
(Mysql::Error)

How do I insert a variable into a row?

Thanks

---

<div class="post-metadata">

**Author:** ![jturney](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e99b99/32.png) [@jturney](https://www.ruby-forum.com/u/jturney)\
**Post date:** [July 2, 2008, 1:25pm UTC](https://www.ruby-forum.com/t/ruby-mysql-insert-variable/141944/2 "2008-07-02T13:25:10Z")

</div>

Well, i solved this by bringing ( ’ ’ ) around the #{k}. Thus your code  
is  
likely to become like this,  
my = Mysql::new(“localhost”, “root”, “pass”, “table”)  
my.query(“INSERT INTO table VALUES(‘2008-05’, ‘#{k}’, 324)”)

Hope it solves it.