软删除及其相关实现 在模型类中要使用SoftDeletestrait并设置$date属性数组 <?php namespace App\Models; use Illuminate\Database\Eloquent\Model; use Illuminate\Database\Eloquent\SoftDeletes; class Student extends Model { use SoftDeletes; //设置表名 public $table = 'students'; //设置主键
package com.lanxi.demo1_8; import java.util.Iterator; import java.util.LinkedList; public class Test { public static void main(String[] args) { LinkedList link=new LinkedList(); for (int i = 1; i <= 10; i++) { link.add("小样"+i); } System.out.p
delete from tb_news where id not in ( select max(id) From tb_news Group By title ) 刚开始用这条语句删除一直不成功 然后百度了一下,说是要建立一张临时表 于是进行了以下操作 先建立一个临时表 CREATE TEMPORARY TABLE tmp_news ( `id` ) ) 然后执行以下语句 delete from tb_news where id not in (SELECT * from ( select m