Insert NULL value in db using Raw sql queries in rails

Question

I am using raw sql queries in my rails application. I want to insert NULL value in one my rows, like how active record does using nil so that i will get that row when i do Table.find_by_column(nil). I tried '#{nil}' its entering as nothing db column is blank like this ' ' i want it to be NULL.

what query you are using, show the complete query how you are trying to do it — Deepesh
– Deepesh, Commented Jun 1, 2015 at 6:21
"INSERT into table_name (r_id, r_name) VALUES (0,'#{nil}')" — Shilpi Agrawal
– Shilpi Agrawal, Commented Jun 1, 2015 at 6:28
try this "INSERT into table_name (r_id, r_name) VALUES (0,null)" — Deepesh
– Deepesh, Commented Jun 1, 2015 at 6:28

Amit Sharma · Accepted Answer · 2015-06-01 06:41:03Z

2

You can also try this.

sql = "INSERT into table_name (r_id, r_name) VALUES (1, null)"

records_array = ActiveRecord::Base.connection.execute(sql)

answered Jun 1, 2015 at 6:41

Amit Sharma

3,4772 gold badges17 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AbuHayA · Accepted Answer · 2015-06-01 06:25:02Z

1

How about nil instead of #{nil}

Table.column = nil

answered Jun 1, 2015 at 6:25

AbuHayA

305 bronze badges

Comments

Sachin R · Accepted Answer · 2015-06-01 06:21:42Z

0

try this

Model.find_by_sql "SELECT * FROM table  where column is NULL"

answered Jun 1, 2015 at 6:21

Sachin R

11.9k11 gold badges37 silver badges42 bronze badges

1 Comment

Shilpi Agrawal Over a year ago

Thank u @SachinR but i want it like like that while inserting it should be raw sql but while searching it will be ActivRecord.

Vrushali Pawar · Accepted Answer · 2015-06-01 06:25:27Z

0

Model.find_by_column(nil)

This will give record which column's value is nil

answered Jun 1, 2015 at 6:25

Vrushali Pawar

3,8131 gold badge16 silver badges22 bronze badges

Comments

webster · Accepted Answer · 2015-06-01 07:02:20Z

0

You can update all records using:

Model.update_all(:field_name => nil)

Then you can find all records that are nil using:

Model.where(:field_name => nil)

answered Jun 1, 2015 at 7:02

webster

4,0326 gold badges41 silver badges61 bronze badges

Collectives™ on Stack Overflow

Insert NULL value in db using Raw sql queries in rails

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related