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();