3 lines
218 B
MySQL
3 lines
218 B
MySQL
|
UPDATE vn.client SET businessTypeFk = 'florist' WHERE businessTypeFk IS NULL;
|
||
|
|
ALTER TABLE vn.client MODIFY COLUMN businessTypeFk varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'florist' NOT NULL;
|