SQL : a condition (IF-ELSE) in INSERT INTO

Question

Is it possible ?

INSERT INTO tblPeople (id, group, company) VALUES (1, 'myGroup', 
IF($company = '') BEGIN 'no company' ELSE 'myCompany' END)

I would like test a value, an if the variable $company is empty, I would like write no company.

Have you tried doing the check before doing the insert? – Kane Jan 08 '13 at 12:40 — Kane, Jan 08 '13 at 12:40
What DBMS are you using? – Daniel Hilgarth Jan 08 '13 at 12:40 — Daniel Hilgarth, Jan 08 '13 at 12:40
in my case, I can not do it before. I use SQL Server – Whitney R. Jan 08 '13 at 12:44 — Whitney R., Jan 08 '13 at 12:44

Robert · Accepted Answer · 2013-01-08T12:50:07.410

28

Try this:

INSERT INTO tblPeople (id, group, company) 
select 1, 'myGroup', 
case 
  when @company is null or  @company = '' then 'no company' 
  else 'myCompany' 
END as  company
/*from tab --<-- optional*/

edited Jan 08 '13 at 12:50

answered Jan 08 '13 at 12:44

Robert

25,425
8
67
81

not working for me ? is this depends on mysql version ? I have created a table like this "create table tutorials_tbl( id INT NOT NULL , company VARCHAR(500) NOT NULL, PRIMARY KEY ( id ) ); " – Mugeesh Husain Jan 11 '21 at 08:51

score 6 · Answer 2 · answered Jan 08 '13 at 12:45

6

Probably not, but

INSERT INTO tblPeople (id, [group], company) 
Select 1, 'myGroup', Case When @Company = '' then 'no company' Else 'my company' End

Should be a goer

answered Jan 08 '13 at 12:45

Tony Hopkinson

20,172
3
31
39

SQL : a condition (IF-ELSE) in INSERT INTO

2 Answers2

Linked