If you are trying to migrate a single class you will do something like this
php artisan migrate --path = path_to_migration_file
if you get something like :
Nothing to migrate
and you are sure the file is there, then you can try to write the command like this
php artisan migrate --path="database/migrations/2022_11_04_1235_create_table.php"
There are a number of ways to view the raw SQL statement of your Larael query builder
A simple way to show you the SQL statement along with its binding is replacing ->get(), first(), .. with ->dd(), here is an example:
$users = User::select('name')
->where('id', '<', 20)
and the output will be like this:
Continue reading “How to view raw SQL of Laravel query?”
"select `name` from `users` where `id` < ? and `is_active` = ?"
0 => 20
1 => 1
If you got an error like: “Host ‘localhost’ is not allowed to connect to this MariaDB server” you can edit the file xampp\mysql\bin\my.ini
Add this line:
after [mysqld] group.
After that, login to phpmyadmin and repair the users table as it mostly is corrupted.
Also try to rename :