Use of `if( ... = ... )` in mysql?

Question

insert into foo_table (fname, lname, number)
values ('John', 'Doe', if(123 = 456));

For the above MySQL query, can somebody kindly explain what the if(123 = 456) is doing? I currently struggle to see an if statement without a body (i.e. if(condition){ // do something });

It would insert a record with the values ('John', 'Doe', 0). As for the reason to have this, you will need to ask the person who wrote it. — FDavidov
– FDavidov, Commented Dec 20, 2016 at 8:11
It's a syntax error. The IF() function requires 3 arguments. The first argument is a condition expression. If it's true the function returns the second argument, otherwise it returns the third argument. — Barmar
– Barmar, Commented Dec 20, 2016 at 8:25

Kiran Kumar · Accepted Answer · 2016-12-20 08:28:58Z

1

The query is syntactically not correct as per mysql version 8, The syntactically correct query is insert into foo_table (fname, lname, number) values ('John', 'Doe', if(123 = 456,1,2)). This will insert 1 if the condition (123 =456) is true, otherwise it will insert 2.

answered Dec 20, 2016 at 8:28

Kiran Kumar

1,0517 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Use of `if( ... = ... )` in mysql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related