zE5p9LBs

1CREATE TABLE IF NOT EXISTS `video_details` (
2  `video_id` int(6) NOT NULL auto_increment COMMENT 'Auto Generated key',
3  `video_name` varchar(50) default NULL,
4  `video_file` varchar(100) default NULL,
5  `how_to_video` varchar(100) default NULL COMMENT 'information video',
6  `video_desc` varchar(50) default NULL,
7  `video_created_date` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
8  `video_status` tinyint(1) default NULL COMMENT '0-->video will not be displayed.,1-->video will be displayed ',
9  PRIMARY KEY  (`video_id`)
10) ENGINE=InnoDB AUTO_INCREMENT=382 DEFAULT CHARSET=utf8;
11
12CREATE TABLE IF NOT EXISTS `video_tag` (
13  `video_id` int(6) default NULL,
14  `tag_id` int(11) default NULL,
15  KEY `FK__tag_details` (`tag_id`),
16  KEY `FK__video_details` (`video_id`),
17  CONSTRAINT `FK__video_details` FOREIGN KEY (`video_id`) REFERENCES `video_details` (`video_id`) ON DELETE CASCADE ON UPDATE CASCADE
18) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
19	
20select vt.video_id , vd.video_name from video_tag vt , video_details vd 
21where vt.tag_id in (1,2)