mysql - INSERT only when IF-condition is true -


i know if there possibility insert row table when if-condition true:

 set @value1 := '1';   set @value2 := '2';   if(@value2 >= @value1)       insert `table`       (`row1`, `row2`)       values       ('valuecheck', 'second value greater first value');  end if; 

mysql reports error #1064 - have error in sql syntax, can't find wrong. insert should executed when if-clause true.

based on this answer, following should work:

set @value1 := '1';  set @value2 := '2';  insert `table` (`row1`, `row2`)      values      ('valuecheck', 'second value greater first value'); @value2 >= @value1 

Comments