如何在Laravel中使用Eloquent清空Grpusr表group_id列的值

Hey there! I get it - you don't want to wipe out the whole record, just reset the group_id value. Here's how you can do that using Laravel's Eloquent (since your code looks like it's using Laravel):

Option 1: Fetch the record, update the column, then save #

This is straightforward if you need to work with the record object for other operations too:

// Grab the specific Grpusr record
$grpusrdel = Grpusr::find($grpusrid);

// Make sure the record exists before updating
if ($grpusrdel) {
    // Set group_id to null (adjust to empty string '' if your column doesn't allow nulls)
    $grpusrdel->group_id = null;
    // Save the changes to the database
    $grpusrdel->save();
}

Option 2: Direct update (more concise) #

If you don't need the full record object, you can update it in one query:

// Update the group_id column directly for the matching record
Grpusr::where('id', $grpusrid)->update(['group_id' => null]);

Bonus: Ensure the record exists (throw exception if not) #

If you want to guarantee the record exists (and throw an error if it doesn't), use findOrFail:

$grpusrdel = Grpusr::findOrFail($grpusrid);
$grpusrdel->group_id = null;
$grpusrdel->save();

Note: If your group_id database column doesn't allow NULL values, replace null with an empty string ('') or another valid default value that fits your schema.

内容的提问来源于stack exchange，提问作者Abdallah Sakre