tutorialpoint

output of using two databases  together Hi everyone working with two database is relay easy and quite impotent. In this case i just take example of teacher and student. At first we make two tables 1 for student and other for teacher. create a database and paste the following sql command to create the two tables ***************************************************************************** Student table   CREATE TABLE IF NOT EXISTS `student` ( `id` int ( 11 ) NOT NULL AUTO_INCREMENT, `student_id` int ( 11 ) NOT NULL , `name` varchar ( 50 ) NOT NULL , `teacher_id` int ( 20 ) NOT NULL , `visibality` int ( 5 ) NOT NULL , ` image ` varchar ( 100 ) NOT NULL , PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 46 ; -- -- Dumping data for table `student` -- INSERT INTO `student` (`id`, `student_id`, `name`, `teacher_id`, `visibality`, ` image `) VALUES ( 1 , 1 , 'Rahul Sen' , 1 , 1 , '' ), ( 2 , 2 ,