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 *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.

You May Also Like…

Squarespace Image Export

To gain continued access to your Squarespace website images after cancelling your subscription you have several...

MySQL 8.x GRANT ALL STATEMENT

-- CREATE CREATE USER 'tgnrestoreuser'@'localhost' IDENTIFIED BY 'AppleSauceLoveBird2024'; GRANT ALL PRIVILEGES ON...

Exetel Opt-Out of CGNAT

If your port forwards and inbound and/or outbound site-to-site VPN's have failed when switching to Exetel due to their...