mysql存储过程

2009-08-07 05:13:31 89 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

RK3588s Camera ISP调优详解（一）ISP调试工具及环境配置（附下载途径）本文主要介绍了rkisp tuner工具的连接与使用，并附上了工具及依赖库的下载地址阅读详情

有一个存储过程，其中有一段代码是这样的：



PREPARE statement FROM

"SELECT     p.product_id, p.name,

IF(LENGTH(p.description) <= ?,

p.description,

CONCAT(LEFT(p.description, ?),

'...')) AS description,

p.price, p.discounted_price, p.thumbnail

FROM       product p

INNER JOIN product_category pc

ON p.product_id = pc.product_id

WHERE      pc.category_id = ?

ORDER BY   p.display DESC

LIMIT      ?, ?";