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
Post a Comment