Skip to content

NimTechnology

Trình bày các công nghệ CLOUD một cách dễ hiểu.

  • Kubernetes & Container
    • Docker
    • Kubernetes
      • Ingress
    • Helm Chart
    • Isito-EnvoyFilter
    • Apache Kafka
      • Kafka
      • Kafka Connect
      • Lenses
    • Vault
    • Longhorn – Storage
    • VictoriaMetrics
  • CI/CD
    • ArgoCD
    • ArgoWorkflows
    • Spinnaker
    • Jenkins
  • Coding
    • Terraform
      • GCP – Google Cloud
      • AWS – Amazon Web Service
    • Golang
    • Laravel
    • Jquery & JavaScript
    • Git
    • Selenium
  • Log & Monitor
    • Prometheus
    • Grafana
    • ELK
      • Kibana
      • Logstash
  • BareMetal
  • Toggle search form

Hướng dẫn thêm column(cột) và change type column cho table bằng command trong Laravel

Posted on June 7, 2021December 9, 2021 By nim No Comments on Hướng dẫn thêm column(cột) và change type column cho table bằng command trong Laravel

Contents

  • 1) add new column to table
  • 2) create table
  • 3) change type column in table
  • 4) Fix lỗi

1) add new column to table

Link: https://stackoverflow.com/questions/16791613/add-a-new-column-to-existing-table-in-a-migration

To create a migration, you may use the migrate:make command on the Artisan CLI. Use a specific name to avoid clashing with existing models

for Laravel 3:

php artisan migrate:make add_paid_to_users

for Laravel 5+:

php artisan make:migration add_paid_to_users_table --table=users

You then need to use the Schema::table() method (as you’re accessing an existing table, not creating a new one). And you can add a column like this:

public function up()
{
    Schema::table('users', function($table) {
        $table->integer('paid');
    });
}

and don’t forget to add the rollback option:

public function down()
{
    Schema::table('users', function($table) {
        $table->dropColumn('paid');
    });
}

Then you can run your migrations:

php artisan migrate

This is all well covered in the documentation for both Laravel 3:

  • Schema Builder
  • Migrations

And for Laravel 4 / Laravel 5:

  • Schema Builder
  • Migrations

Edit:

use $table->integer(‘paid’)->after(‘whichever_column’); to add this field after specific column.

2) create table

Tạo table:

php artisan make:migration create_workload_datasources --create=workload_datasources

create model với laravel 7 thì như sau:

php artisan make:model Models/WorkloadDatasource

3) change type column in table

Schema::table('orders', function ($table) {
    $table->string('category_id')->change();
});

https://stackoverflow.com/questions/32940495/laravel-migration-table-fields-type-change/40047800

Cuối cùng gõ lệnh php artisan migrate

4) Fix lỗi

 SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column `kratos`.`workloads
`.`migrate_end` at row 1 (SQL: alter table `workloads` add `migrate_end` datetime not null)

$table->dateTime('migrate_end')->nullable();

Laravel

Post navigation

Previous Post: Hướng dẫn đưa secret của Kubernetes thành biến env của pod
Next Post: [Jenkins] Hướng dẫn sử dụng Jenkins pipeline to control Jenkins agent in k8s and deploy on k8s

More Related Articles

Các Lệnh query với Model của Laravel eloquent Laravel
[PHP] Hướng dẫn kiểm tra array rỗng hay null không? Laravel
Ví dụ về laravel http client response code Laravel
[Laravel] Hướng dẫn taọ 1 array từ việc tổng hợp nhiều Array lấy từ DB hay API Coding
Vẽ chart cực đẹp bằng Morris JS và hướng dẫn fix lỗi morris không làm việc trên tab của bootstap Jquery & JavaScript
Tự tạo Command “php artisan” cho riêng mình trên web laravel Laravel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Tham Gia Group DevOps nhé!
Để Nim có nhiều động lực ra nhiều bài viết.
Để nhận được những thông báo mới nhất.

Recent Posts

  • Protected: My Assignment  June 24, 2022
  • [Spinnaker] Spinnaker writes too many logs – Reduce spinnaker log level June 22, 2022
  • [Jenkins] Jobs will be created automatically by Jenkins Job Builder June 20, 2022
  • [Postgresql] Install postgresql client and trying a few command postgresql. June 20, 2022
  • [Mount/Nextcloud] How do you mount a hard disk that was used windows into Linux. June 19, 2022

Archives

  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021

Categories

  • BareMetal
  • CI/CD
    • ArgoCD
    • ArgoWorkflows
    • Jenkins
    • Spinnaker
  • Coding
    • Git
    • Golang
    • Jquery & JavaScript
    • Laravel
    • Selenium
    • Terraform
      • AWS – Amazon Web Service
      • GCP – Google Cloud
  • Kubernetes & Container
    • Apache Kafka
      • Kafka
      • Kafka Connect
      • Lenses
    • Docker
    • Helm Chart
    • Isito-EnvoyFilter
    • Kubernetes
      • Ingress
    • Longhorn – Storage
    • Vault
    • VictoriaMetrics
  • Log & Monitor
    • ELK
      • Kibana
      • Logstash
    • Grafana
    • Prometheus
  • Uncategorized
  • Admin

Copyright © 2022 NimTechnology.