1、mysql通过replace函数实现字符替换
update `user` SET `name` = replace (`name`,'张','赵') where `name` LIKE '%张%'
SELECT * FROM `user` where FIND_IN_SET(age,"18,20,22");
select version();
select * from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = 'activiti' order by create_time desc;
SELECT table_schema,table_name,create_time FROM information_schema.tables WHERE table_schema='activiti'
如果觉得我的文章对您有用,请随意打赏。你的支持将鼓励我继续创作!