TP6数据库操作语句（mysql）

查询

$tmp = Db::table('think_tp')->where('email','thinkphp@qq.com')->select();

返回的是数组
使用$tmp[0]['aaaa']

---

单条查询

$tmp = Db::table('think_tp')->where('email','thinkphp@qq.com')->find();

返回的是单条的数组内容

使用$tmp['aaaa']

---

增

$data = [
 'nickname' => 'AJ1', 
 'email' => 'AJ1@qq.com' 
 ];
 
Db::table('think_tp')->insert($data);

批量增

$date = [[ 'nickname' => 'AJ1', 'email' => 'AJ1@qq.com' ],[ 'nickname' => 'AJ2', 'email' => 'AJ2@qq.com' ]];
			$result = Db::table('think_tp')->insertAll($date);
			if($result){
				return '操作成功';
			}else{
				return '操作失败';
			}

---

删

$result = Db::table('think_tp')->delete('4');

---

改

Db::table('think_tp')->where('id','3')->update([ 'nickname' => 'AJ', 'email' => 'AJ@qq.com' ]);

自增

Db::table('think_tp')->where('id','1')->inc('email')->update();

自减

Db::table('think_tp')->where('id','1')->dec('email')->update();