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
      • Pod
    • Helm Chart
    • Isito-EnvoyFilter
    • Apache Kafka
      • Kafka
      • Kafka Connect
      • Lenses
    • Vault
    • Longhorn – Storage
    • VictoriaMetrics
    • MetalLB
    • Kong Gateway
  • CI/CD
    • ArgoCD
    • ArgoWorkflows
    • Spinnaker
    • Jenkins
    • Harbor
    • TeamCity
    • Git
      • Bitbucket
  • Coding
    • DevSecOps
    • Terraform
      • GCP – Google Cloud
      • AWS – Amazon Web Service
    • Golang
    • Laravel
    • Python
    • Jquery & JavaScript
    • Selenium
  • Log, Monitor & Tracing
    • DataDog
    • Prometheus
    • Grafana
    • ELK
      • Kibana
      • Logstash
  • BareMetal
    • NextCloud
  • 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

Tự tạo Command “php artisan” cho riêng mình trên web laravel Laravel
[Laravel] Handle datetime easily with Carbon in Laravel. Laravel
[Laravel] Create file controller in Laravel. 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
[Popup/Ajax] Tạo popup(modal/bootstrap) insert data bằng ajax và php Coding
Các Lệnh query với Model của Laravel eloquent 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

  • [AWS] Look into Data Transfer on AWS May 30, 2023
  • [Ddosify] How to test the application performance with Ddosify. May 30, 2023
  • [DevSecOps/TruffleHog] Find your repository’s secrets, sensitive words, and credentials. May 29, 2023
  • [DevSecOps] Tìm hiểu về thu thập thông tin. May 25, 2023
  • [coralogix/OpenTelemetry] Monitor Your K8s by Coralogix and OpenTelemetry Collector. May 24, 2023

Archives

  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • 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
    • NextCloud
  • CI/CD
    • ArgoCD
    • ArgoWorkflows
    • Git
      • Bitbucket
    • Harbor
    • Jenkins
    • Spinnaker
    • TeamCity
  • Coding
    • DevSecOps
    • Golang
    • Jquery & JavaScript
    • Laravel
    • Python
    • Selenium
    • Terraform
      • AWS – Amazon Web Service
      • GCP – Google Cloud
  • Kubernetes & Container
    • Apache Kafka
      • Kafka
      • Kafka Connect
      • Lenses
    • Docker
    • Helm Chart
    • Isito-EnvoyFilter
    • Kong Gateway
    • Kubernetes
      • Ingress
      • Pod
    • Longhorn – Storage
    • MetalLB
    • Vault
    • VictoriaMetrics
  • Log, Monitor & Tracing
    • DataDog
    • ELK
      • Kibana
      • Logstash
    • Fluent
    • Grafana
    • Prometheus
  • Uncategorized
  • Admin

Copyright © 2023 NimTechnology.