Laravel 数据库操作

DB::insert('insert tb1 values(?,?,?)',[null,'tom',10]);

DB::select('select * from tb1 where id = :id',['id'=>1]);

DB::update('update tb1 set name=? where id = ?',['khs1994',1]);

DB::delete('delete from tb1');

DB::statement('drop table tb1');

DB::table('tb1')->get();

DB::table('tb1')
  ->where('name','John')
  ->first();

DB::table('tb1')
  ->where('name','John')
  ->value('age')

DB::table('tb1')
  ->pluck('title')