Mysql索引记录
IO成本和CPU成本:
https://blog.csdn.net/sermonlizhi/article/details/124534608
mysql模糊查询:防止用户输入%全表查询,简单sql注入风险写法
查询包含%的物料,防止返回全部数据.
SELECT * FROM `product` where POSITION('%' in `name`);
SELECT * FROM `product` WHERE INSTR(`name`, '#' );IO成本和CPU成本:
https://blog.csdn.net/sermonlizhi/article/details/124534608
查询包含%的物料,防止返回全部数据.
SELECT * FROM `product` where POSITION('%' in `name`);
SELECT * FROM `product` WHERE INSTR(`name`, '#' );