3 lines
184 B
MySQL
3 lines
184 B
MySQL
|
ALTER TABLE vn.clientObservation MODIFY COLUMN observationTypeFk tinyint(3) unsigned DEFAULT 4 NOT NULL;
|
||
|
|
UPDATE vn.clientObservation SET observationTypeFk=4 WHERE observationTypeFk=0;
|