tp6操作数据库

大得369

已于 2023-04-10 19:16:06 修改

阅读量224

点赞数

分类专栏： php 文章标签：数据库 sql mysql

于 2022-11-25 22:15:22 首次发布

本文链接：https://blog.csdn.net/qq_34631220/article/details/128045520

版权

php 专栏收录该内容

76 篇文章 1 订阅

订阅专栏

这篇博客展示了多种数据库操作，包括根据条件查询数据、链表查询、更新记录、批量插入、选择性复制数据以及执行删除操作。示例使用了PHP的Db类进行操作，涵盖了基本的CRUD操作，以及在数据处理中的常见场景。

摘要由CSDN通过智能技术生成

//排除字段id查询
Db::table('cdj_order')
->whereRaw("PaidChargeSum<0.01")
->withoutField('id',false)
->whereIn("id",$id)
->select()
->toArray();


//链表查询
Db::table('think_user')
->alias('a')
->join(['think_work'=>'w'],'a.id=w.artist_id')
->join(['think_card'=>'c'],'a.card_id=c.id')
->select();

//修改
Db::name('user')
    ->where('id', 1)
    ->update(['name' => 'thinkphp']);

Db::execute("update dade_order_goods set name=$name,price=$price where id=$id");

//一次写100条
Db::table('cdj_order_check')
->limit(100)
 ->insertAll($order);

//插入
//cdj_order表所有字段
$table = Db::query("select COLUMN_NAME from information_schema.COLUMNS where TABLE_NAME='cdj_order'");
 $name = '';
foreach ($table as $key=>$it){
     if($it['COLUMN_NAME'] != 'id'){
           if(empty($name)){
              $name = $it['COLUMN_NAME'];
           }else{
              $name .= ",".$it['COLUMN_NAME'];
           }
     }
     
}
Db::execute("insert into cdj_order_check($name) select $name from cdj_order where $where");

//删除
Db::execute("delete from cdj_order where $where");
//删除
Db::table('cdj_order_check')->whereIn("id",$id)->delete();

select COLUMN_NAME from information_schema.COLUMNS where TABLE_NAME='cdj_order' and COLUMN_NAME not in (select COLUMN_NAME from information_schema.COLUMNS where TABLE_NAME='cdj_order_check');
select COLUMN_NAME from information_schema.COLUMNS where TABLE_NAME='cdj_order_check' and COLUMN_NAME not in (select COLUMN_NAME from information_schema.COLUMNS where TABLE_NAME='cdj_order');