我有两张桌子:一张是tbl_videos,另一张是tbl_categories_videos。tbl_videos有两个类别字段,这两个字段都取自tbl_categories_videos。无论如何,下面是视图的SQL:SELECT `tbl_videos`.`videos_id` AS `videos_id`,
`tbl_videos`.`date` AS
我有一个存储过程,它将提供最新的记录 convert(varchar,videos.posteddate,106) as posteddate,videos.approvedstatus,
videos.videoimage,(ISNULL(videos.views,0.0)) as [views],
我有一个这样的查询 (SELECT COUNT(comment_id) WHERE comments.comments_video_id= videos.id) AS video_commentsORDER BY video_comments DESC
现在,如果我有两行具有相同的'videos_comments
以下是单独的查询:SELECT videos.vid, videos.mid, videos.source, videos.category, videos.title,videos.description, videos.date_added, videos.status, members.name FROM videos LEFT JOIN members ON video
我有以下问题。视频有多个标签,如高清晰度、720p、1080p等,每个标签都有自己的记录。所有标签都在自己的表中,其命名的标签。CREATE TABLE IF NOT EXISTS `tag` ( `video_id` bigint(20) DEFAULT NULL,
`tag_name` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ''