Laravel and MySQL

Running serve

php artisan serve

Check list

php artisan list

Create controller

php artisan make:controller ProductController

Link to storage

php artisan storage:link

DB

mysql -u root -p
show databases;

Create database

create database laravel

Show all databases

show databases;

Use database

use database_name;

Show tables

show tables;

Create model and migration

php artisan make:model Post -m

Migrate

php artisan migrate

Describe

describe posts;

Reset database: delete all table

php artisan migrate:reset

Refresh database : migrate and rollback

php artisan migrate:refresh

Fake data

php artisan make:factory PostFactory

Create factory: php artisan tinker

\App\Models\Post::factory()->create();
\App\Models\Post::factory()->count(5)->create();

SELECT CMD

SELECT * FROM table_name;

EXIT CMD INSIDE DB

exit;

DROP TABLE MySQL

DROP TABLE IF EXISTS food; 

Create rule validate

php artisan make:rule Uppercase

Create request validate

php artisan make:request CreateValidationRequest

Add column

php artisan make:migration add_image_to_foods