分页,用offset增强语义化
select *
from db.product limit 20 offset 0;
--limit 0, 20;
增加外键约束
ALTER TABLE db.productId
...
MySQL configurate my.ini: Max packet size default: 1M
select *
from db.product limit 20 offset 0;
--limit 0, 20;
ALTER TABLE db.productId
...
MySQL configurate my.ini: Max packet size default: 1M