How to copy values from one column to another using CakePHP 4 Query Builder

Written by James McDonald

July 9, 2020

I want to change the name of a column in my database and to do that I have to create a migration and drop a table

The query I want to run is

UPDATE pallets 
SET 
    production_date = print_date;

Seem so simple in SQL but to do it in CakePHP 4 took some finding

Copy data between columns in CakePHP 4

        $builder = $this->getQueryBuilder();
        
        $exp = $builder->newExpr('print_date');

        $statement = $builder->update('pallets')->set('production_date', $exp);

        $statement->execute();

When you debug($statement) you get the following in the Query Object

'sql' => 'UPDATE pallets SET production_date = (print_date)'

0 Comments

Submit a Comment

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

You May Also Like…

Toggen builds a new website

So I have built and hosted a new website for Roger Clark Pest Management they are a family owned and operated Pest...

WizTree

Just downloaded WizTree (not a sponsor) from https://wiztreefree.com/ It seems to do what it says on the tin which is...

Scam call from “Telstra”

Just had a call from a man with a sub-continental accent from caller ID 0734946596 Told me there was problem with my...