Back

Laravel DB:table

Copy Below Code View As A Text File Show Text Only Show API Edit Code
                            

->whereNull('updated_at') ->whereNotNull('updated_at') ->whereDate('created_at', '2016-12-31') ->whereMonth('created_at', '12') ->whereDay('created_at', '31') ->whereYear('created_at', '2016') ->whereTime('created_at', '=', '11:20:45') ->whereColumn('updated_at', '>', 'created_at') ->orWhere('title', '=', 'Admin'); //INSERT QUERY DB::table('users')->insert([ ['email' => 'taylor@example.com', 'votes' => 0], ['email' => 'dayle@example.com', 'votes' => 0] ]); ///Auto-Incrementing IDs $id = DB::table('users')->insertGetId( ['email' => 'john@example.com', 'votes' => 0] ); /////////////// DELETE DB::table('users')->where('votes', '>', 100)->delete();