Thinkphp 5追加削除

namespace app\index\controller;

use think\Controller;
use think\db; //    

class Index extends Controller 
{
    public function index()
    {
        /*  */

        //db()    
        $userName = db('user_list')->field('user_name')->select();

        //table             
        $userInfo22 = db::table('wts_user_list')
       ->where(array('user_id'=>22))->find();

        //name  
        $userId = db::name('user_list')->field('user_id')->select();

        //Query  
        $query = new \think\db\Query();
        $userTitle = $query->name('user_list')->column('user_title');


        /*  */
        db::name('bulletin_list')->where('bulletin_id',67)
        ->update(['bulletin_title'=>'  ']);

        //          
        db('user')->where('id',1)->update(['name' => 'thinkphp']);
        //         
        db('user')->where('id',1)->setField('name','thinkphp');
        //    score   
        db('user')->where('id', 1)->setInc('score');
        //    score   
        db('user')->where('id', 1)->setDec('score');



        /*  */

        //       
        Db::table('think_user')->delete(1);
        Db::table('think_user')->delete([1,2,3]);

        //     
        Db::table('think_user')->where('id',1)->delete();
        Db::table('think_user')->where('id',',10)->delete();

        //       
        db('user')->delete(1);
        //     
        db('user')->where('id',1)->delete();



        /*  */
        $data = ['foo' => 'bar', 'bar' => 'foo'];
        Db::table('think_user')->insert($data);

        $data = [
            ['foo' => 'bar', 'bar' => 'foo'],
            ['foo' => 'bar1', 'bar' => 'foo1'],
            ['foo' => 'bar2', 'bar' => 'foo2']
        ];
        Db::name('user')->insertAll($data);$data = [
        ['foo' => 'bar', 'bar' => 'foo'],
        ['foo' => 'bar1', 'bar' => 'foo1'],
        ['foo' => 'bar2', 'bar' => 'foo2']
        ];
        Db::name('user')->insertAll($data);

       
        return $this->fetch('index');
    }
}