MYQL字符串操作实例

来源:互联网 发布:ps4应用程序数据损坏 编辑:程序博客网 时间:2024/05/01 10:05
UPDATE `qualivm1_ordermanagement`.`ecs_fellow_website` SET `site_info` = '.com' WHERE `ecs_fellow_website`.`id` = 1;

UPDATE `qualivm1_ordermanagement`.`ecs_fellow_website` SET `site_info` = REPLACE(`site_info`, '.com', '') WHERE `ecs_fellow_website`.`id` = 1 


0 0
原创粉丝点击