mysql - Laravel update based on other value -


how can translate used within laravel query builder ?

mysql

update mytable set val = val +1 id = 1

in laravel

$res = db::table('mytable') ->update(['val' => ?]);

thanks

try:

db::table('mytable')->where('id',1)->increment('val');

the increment method accept second parameter amount sum, if need val = val + 2 can use ->increment('val', 2).

see reference: https://laravel.com/api/5.3/illuminate/database/eloquent/builder.html#method_increment


-

Comments

Post a Comment

Popular posts from this blog

sql - MySQL - Finding Empty relations -

i trying work out how full list of team leaders , team members our tables. including team leaders have no team. we have basic data structure have table person contains our basic person object. people extend table in details table. one of extended pieces of information have team_leader status. have 2 relevant details define this: detail_isteamleader , detail_teamleader . first boolean , defines short list of team leaders. second defines persons team leader (ideally subset). _person table_ person_id person_name _detail table_ detail_id detail_person_id detail_isteamleader detail_teamleader i can team leaders have team using following query: select tl.person_id tlref, tl.person_name tlname, per.person_id perref, per.person_name pername detail left outer join person per on detail.person = per.person_id left outer join person tl on detail_teamleader = tl.person_id order tlname, psname however, fails team_leaders detail.isteamleader true not occur in detail_teamleader...
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js ...
Read more

date - Java 8 - Trying to convert String to LocalDateTime -

this question has answer here: java string date conversion 13 answers i trying convert below string localdatetime , somehow not working. val formatter = datetimeformatter.ofpattern("yyyy-mm-dd hh:mm:ss.sss"); val datetime = localdatetime.parse("2016-09-21 13:43:27.000", formatter); it seems there problem in pattern. you have problem pattern, should use 'h' hours(0-23). type formatter , datetime wrong. work correctly: datetimeformatter formatter = datetimeformatter.ofpattern("yyyy-mm-dd hh:mm:ss.sss"); localdatetime datetime = localdatetime.parse("2016-09-21 13:43:27.000", formatter);
Read more