使用原生sql语句
select
DB::select('select * from table_name');
$sql="select * from table_name where gender='female'";
DB::select($sql);
$sql = 'INSERT INTO users(`name`,`age`) values(?,?);
DB::table('table_name')->insert( $sql ,['yan',18]);
查询数据
where
first()返回一条数据
DB::table('table_name')->where('id','1')->first();
get()返回多条数据
DB::table('table_name')->where('gender','female')->get();
比较数值
DB::table('table_name')->where('age','>=',18)->get();
模糊查询
DB::table('table_name')->where('age','like',18)->get();
插入数据
insert
- 插入单行数据
DB::table('table_name')->insert(['username'=>'yan','gender'=>'female']);
- 插入多条数据
DB::table('table_name')->insert([
['username'=>'ha'],
['username'=>'haha'],
['username'=>'hahaha']
]);
插入数据并且返回新增的数据的id
$id=DB::table('table_name')->insertGetId([
'username'=>'bella',
'gender'=>'female',
'age'=>'18',
'email'=>'777777@qq.com'
]);
echo $id;
修改数据
update
修改特定条件的数据
DB::table('table_name')->where('id',9)->update(['username'=>'yan','gender'=>'female']);
删除数据
delete
删除特定条件的数据
DB::table('table_name')->where('gender','male')->delete();
删除所有数据
DB::table('table_name')->delete();
清空数据表所有数据并且设自增id为0
DB::table('table_name')->truncate();
待补充
