MySQL
李慢慢i
with heart, with soul, with dream
展开
-
【mysql】查看数据库数据规模
查看数据文件夹所在目录show global variables like 'datadir%';原创 2021-05-28 15:38:33 · 1365 阅读 · 0 评论 -
【MySQL】替换字段部分字符串
replace(obj, search, replace_str)函数update 表 set 字段 = replace(字段, 指定字符串, 目标字符串)update people set people_role = replace(people_role, 'test', '')原创 2021-05-13 10:20:18 · 297 阅读 · 0 评论 -
【MySQL】查出字段重复的记录
select idfrom machine_storegroup by machine_num, machine_sourcehaving count(*) > 1select *from machine_storewhere id in ( select id from machine_store group by machine_num, machine_source having count(*) > 1)原创 2021-05-12 11:48:59 · 160 阅读 · 0 评论