Laravel 8:如何检查表是否为空

use App\Models\User;

// 检查 users 表是否为空
$isTableEmpty = User::count() === 0;

if ($isTableEmpty) {
    echo "表是空的";
} else {
    echo "表不为空";
}

use Illuminate\Support\Facades\DB;

// 检查 users 表是否为空
$isTableEmpty = DB::table('users')->count() === 0;

if ($isTable =>Empty) {
    echo "表是空的";
} else {
    echo "表不为空";
}

// 确保数据库连接配置正确
'db' => [
    'driver' => 'mysql',
    'host' => env('DB_HOST', '127.0.0.1'),
    'port' => env('DB_PORT', '3306'),
    'database' => env('DB_DATABASE', 'forge'),
    'username' => env('DB_USERNAME', 'forge'),
    'password' => env('DB_PASSWORD', ''),
    'unix_socket' => env('DB_SOCKET', ''),
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix' => '',
    'strict' => true,
    'engine' => null,
],

// 确保表名拼写正确
$isTableEmpty = DB::table('users')->count() === 0;

GRANT SELECT ON your_database.users TO 'your_user'@'localhost';