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
@maryloucortez796910 ай бұрын
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!
@shatirdimag10113 ай бұрын
Best video thanks💯
@tel697563746510 ай бұрын
So if u just want to rename one column you will have to go through allll this >?
@shatirdimag10113 ай бұрын
Keep adding more videos
@afnanjaved1986 Жыл бұрын
My migration failed to update the column name . Why ?
@RaefetOuafiqo Жыл бұрын
same here, did you find the solution ?
@salmatamerz27566 ай бұрын
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❤️
@gurujilife72103 ай бұрын
nice
@dawghouse111110 ай бұрын
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`")
@Bitfumes10 ай бұрын
this seems correct please check your database if you have name field or not
@pallavsharma93445 ай бұрын
I can't open tableplus on my ubantu system. Can you help?
@GZRBangBang6 ай бұрын
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.
@SyedAli-ps9ym Жыл бұрын
Will we get the full course on KZbin or there is some paywall
@Bitfumes Жыл бұрын
Around 5 hours of module is free on youtube and rest will be paid
@weler24915 ай бұрын
I'm having an error when trying to update the column name. SQLSTATE[42000]: Syntax error or access violation: 1064....
@md.lutfulbari438 Жыл бұрын
really grateful to u.
@bernardchisumo4054 Жыл бұрын
Is table plus free? I have downloaded but it keeps asking me to pay
@Bitfumes Жыл бұрын
free for 2 tabs only
@user-ue4kh8un3n11 ай бұрын
สอนดีมากครับ ขอบคุณครับ
@sodr4c Жыл бұрын
can u make video for publishing? laravel X react? via local with laragon
@zilpahnamutali9355 Жыл бұрын
are we supposed to download table plus?
@pedroaltomar2380 Жыл бұрын
TablePlus is an app that lets you see and interact with your databases, both local and remote. There are alternative apps that can do the same.