以编程方式重置MySQL默认值

Question

Is it possible to set default values for MySQL columns in CakePHP? I have access default value for user table as:

$fields = $this->User->schema(); 
$defaultValue = $fields['Amount']['default'];

Now I want to change this default value to any particular value provided by admin .. Is it possible ?

Answer 1

Try altering the schema:

ALTER TABLE dbo.table
ADD CONSTRAINT def_mycolumn DEFAULT Amount FOR mycolumn