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