命令行修改站点根网址

-- 修改站点根网址

UPDATE lys_config SET value = 'https://你 的新域名/' WHERE name = 'site_url';

-- 验证修改结果

SELECT name, value FROM lys_config WHERE name IN ('site_url', 'site_filing', 'site_security_number');

-- 修改网站备案号

UPDATE lys_config SET value = '豫ICP备2021024209号-2' WHERE name = 'site_filing';

-- 修改公安备案号

UPDATE lys_config SET value = '豫公网安备41032402000129号' WHERE name = 'site_security_number';

-- 批量查询所有配置

SELECT id, name, title, value FROM lys_config;

-- 更改视频播放外链网址

UPDATE lys_category SET pclink = 'https://nod.dpdns.org/video/' WHERE catid = 16;

-- 验证修改结果

SELECT catid, catname, pclink FROM lys_category;