Level 70
@alexgodbehere79 I assume you want to truncate a database table. In that case, you can try-
Model::query()->truncate();
Note: Plz replace the word Model with your model name.
7 likes
Dec 23, 2020
8
Level 1
How to truncate laravel table?
Hello, I want to truncate laravel model on the console command. Is there any easy way to do that? Thank you in advanced.
Level 75
4 likes
Level 5
Also, thru the DB facade:
DB::table('tableName')->truncate();
6 likes
Level 2
Anyone knows why Model::truncate() wouldn't work on a script, but does work from Tinker? Believe it or not, it happens to me.
1 like
Level 50
@internetbug256 When you say script, what do you mean? And what error do you get?
Level 2
@JussiMannisto I mean that I put that sentence inside some controller, and seems to execute, but NOT truncating the table. However, when I run it from Tinker, it does clear the table.
Level 50
@internetbug256 That shouldn't happen, obviously. There's something wrong, but it's hard to say what exactly without the code.
Level 1
Run the command:
php artisan make:command TruncateTable
Open app/Console/Commands/TruncateTable.php and update it like this:
<?php
namespace App\Console\Commands;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
class TruncateTable extends Command
{
protected $signature = 'table:truncate {table}';
protected $description = 'Truncate a specific MySQL table';
public function handle()
{
$table = $this->argument('table');
// Disable foreign key checks temporarily
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
// Truncate the table
DB::table($table)->truncate();
// Re-enable foreign key checks
DB::statement('SET FOREIGN_KEY_CHECKS=1;');
$this->info("Table '{$table}' has been truncated.");
}
}
Now you can run your command like this:
php artisan table:truncate your_table_name
Replace your_table_name with the actual name of your MySQL table.
Please or to participate in this conversation.