![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
emoven
活泼,开朗,好奇
展开
-
mysql表分区
alter table t_result_part partition by range (unix_timestamp(create_time)) ( partition p1 values less than (unix_timestamp('2021-10-01')), partition p2 values less than (unix_timestamp('2021-10-05')), partition p3 values less than (...原创 2021-10-14 10:23:00 · 127 阅读 · 0 评论 -
MySQL分页实现
mysql> select pname from product;+--------+| pname |+--------+| 产品1 || 产品2 || 产品三 |+--------+3 rows in set (0.00 sec)这个地方是说,从product中选出所有的pname来,一共有三条记录。MySQL中的分页非常简单,我们可以原创 2014-05-09 11:45:15 · 3192 阅读 · 0 评论