Laravel 10 full course for beginner - Understand the migrations

No video

Laravel 10 full course for beginner - Understand the migrations

Рет қаралды 28,744

Bitfumes - AI & LLMs

Күн бұрын

Пікірлер: 44

@ntcc2821 Жыл бұрын

I have watched more than 6 Laravel tutorials I must say this guy teaches so well , I like how he doesn't assume you know some things, like he teaches from scratch. If you a complete beginner let me tell you this is the course for you dont waste your time much searching for another one, i have gone throught that trouble for you and im telling this is the best of the best

@bernardchisumo4054 Жыл бұрын

Updating the columns is throwing errors SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'column `name` to `username`' at line 1 (Connection: mysql, SQL: alter table `users` rename column `name` to `username`) php artisan make:migration update_user_table_name_to_username --table=users public function up(): void { Schema::table('users', function (Blueprint $table) { $table->renameColumn('name', 'username'); }); } public function down(): void { Schema::table('users', function (Blueprint $table) { $table->renameColumn('username', 'name'); }); }

@yasin_khadem Жыл бұрын

hi, you can run command `composer require doctrine/dbal` then run your migration 😉

@dr.muhammadbarzakh Жыл бұрын

@@yasin_khadem thanks, it solved the problem.

@tabbechzineeddine782 Жыл бұрын

@@yasin_khadem god bless you

@RaefetOuafiqo Жыл бұрын

hi yassin, why does this package solves this issue ? i know the problem is from MariaDb or MySQL cuz laravel generates this query 'alter table tb_name rename column name to name2' and this doesn't work with MariaDb or MySql ? so how does that package solves this issue behind the scene @@yasin_khadem

@maryloucortez7969 10 ай бұрын

Hi I had the same problem and it works. Thank you@@yasin_khadem

@rollandson26 Жыл бұрын

instead of manually reverting the username to name. use "php artisan migrate:rollback".. cause the schema already setup for rollback ``` public function down(): void { Schema::table('users', function (Blueprint $table) { $table->renameColumn('username', 'name'); }); } ```

@konako00 Жыл бұрын

this is the best laravel tutorial on youtube man

@Bitfumes Жыл бұрын

thanks man👋

@basilistigris640 Жыл бұрын

one more perfect lesson for laravel 10, i like this channel like no other!

@shatirdimag1011 3 ай бұрын

Best video thanks💯

@tel6975637465 10 ай бұрын

So if u just want to rename one column you will have to go through allll this >?

@shatirdimag1011 3 ай бұрын

Keep adding more videos

@afnanjaved1986 Жыл бұрын

My migration failed to update the column name . Why ?

@RaefetOuafiqo Жыл бұрын

same here, did you find the solution ?

@salmatamerz2756 6 ай бұрын

Why did we use table plus and are there any alternatives? Other than that thank you for putting effort in the content , we really appreciate it❤️

@gurujilife7210 3 ай бұрын

nice

@dawghouse1111 10 ай бұрын

hi, Lost at solving this: Trying to change the column name from name to lastname on the default table called users and receiving the error message below: Laravel 10 new build my setyp: Apache 2.4.56 - MariaDB 10.4.28 - PHP 8.2.4 public function up(): void { Schema::table('users', function (Blueprint $table) { $table->renameColumn('name', 'lastname'); }); } ----Error message --- 1 vendor\laravel\framework\src\Illuminate\Database\Connection.php:574 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'column `name` to `lastname`' at line 1") 2 vendor\laravel\framework\src\Illuminate\Database\Connection.php:574 PDO::prepare("alter table `users` rename column `name` to `lastname`")

@Bitfumes 10 ай бұрын

this seems correct please check your database if you have name field or not

@pallavsharma9344 5 ай бұрын

I can't open tableplus on my ubantu system. Can you help?

@GZRBangBang 6 ай бұрын

How did the "renameColumn" suggestion pop up in VS Code at 9:38? Is there an extension needed for Laravel because it didn't show up for me. Would love to add that to my workflow.