mysql设置表主键重1开始

<if test="ids.size > 0">
                <foreach collection="ids" item="item" index="index" open="AND" close="" separator="or">
                    FIND_IN_SET (#{item},warehouse_id)
                </foreach>
            </if>

1、重新设置表主键重1开始

alter table interface_call_time_consuming drop id; -- 删除原来的主键值
alter table interface_call_time_consuming add id int not null primary key auto_increment first; -- 重新从1开始编号，使它连续

2、FIND_IN_SET函数查询 1,2,3,4

SELECT * FROM `rd_resource_dir` WHERE  FIND_IN_SET(2,realm_id);

3、GROUP_CONCAT多行数据字段拼接

SELECT GROUP_CONCAT(id) FROM `realm_data` WHERE `name` in("信用服务","医疗卫生");

4、查看本地mysql安装路径

show variables like "%datadir%";