随机 10条数据
SELECT * FROM `mac_vod` WHERE vod_id >= (SELECT floor(RAND() * (SELECT MAX(vod_id) FROM `mac_vod`))) ORDER BY vod_id LIMIT 10
显示指定范围数据
其中0代表从第一条数据开始；
1代表往后去几条数据；
从0开始取5条数据
select * from `mac_vod` limit 0,5
从5开始取3条数据
select * from `mac_vod` limit 5,3
显示最后一条数据
select * from `mac_vod` order by `vod_id` desc limit 1
随机显示指定类型5条数据
select * from `mac_vod` WHERE vod_id >= (SELECT floor( RAND() * ((SELECT MAX(vod_id) FROM `mac_vod`)-(SELECT MIN(vod_id) FROM `mac_vod`)) + (SELECT MIN(vod_id) FROM `mac_vod`))) AND `type_id`= 3 ORDER BY vod_id LIMIT 5";
SELECT * FROM `mac_vod` WHERE vod_id >= (SELECT floor(RAND() * (SELECT MAX(vod_id) FROM `mac_vod`))) AND `type_id`= 3 ORDER BY vod_id LIMIT 10
显示指定库总数量
select count(*) FROM `mac_vod` WHERE `type_id` = 33
`mac_vod`
`vod_time_add`
//正常显示数据 最新时间显示指定类型(cid)从第0条开始显示3条数据
SELECT * FROM `mac_vod` WHERE `type_id` = 1 ORDER BY `vod_time_add` DESC limit 0,3
//随机显示数据 随机显示指定类型5条数据
SELECT * FROM `mac_vod` WHERE vod_id >= (SELECT floor( RAND() * ((SELECT MAX(vod_id) FROM `mac_vod`)-(SELECT MIN(vod_id) FROM `mac_vod`)) + (SELECT MIN(vod_id) FROM `mac_vod`))) AND `type_id`= 33 ORDER BY vod_id LIMIT 5
//显示指定ID详细数据 .php?sql=vod_vod&type=id&vod_id=100 'SELECT * FROM ff4_vod WHERE `vod_id` =100
SELECT * FROM `mac_vod` WHERE vod_id = 100
//搜索影视名称 包含 老顽童 相关数据，并显示5条 ASC是指定列按升序排列，DESC则是指定列按降序排列
SELECT * FROM `mac_vod` WHERE `vod_name` like '%老顽童%' ORDER BY `vod_time_add` DESC LIMIT 5
SELECT * FROM `mac_vod` WHERE `vod_name` like '%老顽童%' ORDER BY `vod_time_add` DESC LIMIT 0,3
//搜索包含古天乐人相关数据，并显示5条
SELECT * FROM `mac_vod` WHERE `vod_actor` like '%古天乐%' ORDER BY `vod_time_add` DESC LIMIT 5
// 从第1条开始 显示3条数据
SELECT * FROM `mac_vod` WHERE `vod_actor` like '%古天乐%' ORDER BY `vod_time_add` DESC LIMIT 0,3
// 从第4条开始 显示5条数据
SELECT * FROM `mac_vod` WHERE `vod_actor` like '%古天乐%' ORDER BY `vod_time_add` DESC LIMIT 3,5
//显示总数量
select count(*) FROM `mac_vod`
//显示指定库总数量
select count(*) FROM `mac_vod` WHERE `type_id` = 33
//显示指定时间后更新多少条数据
select count(*) FROM `mac_vod` WHERE vod_time_add > 1558022400
//显示指定时间后 指定类型更新多少条数据
select count(*) FROM `mac_vod` WHERE vod_time_add > 1558022400 and `type_id` = 10
select count(*) FROM `mac_vod` WHERE `type_id` = 33 and vod_time_add > 1595779200
//显示当天更新多少条数据
select count(*) FROM `mac_vod` WHERE vod_time_add > 获取当天24点的时间戳
//显示当天 指定类型更新多少条数据 .php?sql=vod_vod&type=ciddttime&cid=10
select count(*) FROM `mac_vod` WHERE vod_time_add > \$today and `type_id` = 10
20200727 时间戳 1595779200
输出调试文本 (时间_到时间戳 (到时间 (取日期 (取现行时间 ())), 真, ))
类型上级归 查看所以电影
mac_type
type_id 上级 type_id
电影 type_id = 1
上级 type_pid = 0 一级
动作 type_id = 6
上级 type_pid = 1 二级
查询一级分类为电影的数量
SELECT count(*) FROM `mac_vod` WHERE `type_id_1` = 1
查询一级分类为电影的数量 当天更新数据 20200727 时间戳 为 1595779200
SELECT count(*) FROM `mac_vod` WHERE `type_id_1` = 1 and vod_time_add > 1595779200
