MySQL Forums
Forum List  »  Stored Procedures

Re: Display all the records from table using cursor
Posted by: kaji Pasa
Date: September 26, 2017 01:27PM

Thanks Peter. Here is my dump version of tables. I have used base_report_gt_zero as the base report table.
Table Base_report_gt_zero( create table Base_report_gt_zero as select * from base_report where cc >0);

-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: localhost Database: test
-- ------------------------------------------------------
-- Server version 5.7.19-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `base_report_gt_zero`
--

DROP TABLE IF EXISTS `base_report_gt_zero`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `base_report_gt_zero` (
`base_report_id` int(11) NOT NULL DEFAULT '0',
`StandardTitle` varchar(255) DEFAULT NULL,
`Title_sci` varchar(255) DEFAULT NULL,
`ISSN1` varchar(12) DEFAULT NULL,
`ISSN2` varchar(12) DEFAULT NULL,
`CC` int(11) NOT NULL,
`Title` varchar(255) DEFAULT NULL,
`ISSN` varchar(12) DEFAULT NULL,
`eISSN` varchar(12) DEFAULT NULL,
`Databas` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `base_report_gt_zero`
--

LOCK TABLES `base_report_gt_zero` WRITE;
/*!40000 ALTER TABLE `base_report_gt_zero` DISABLE KEYS */;
INSERT INTO `base_report_gt_zero` VALUES (2,'ACADEMIA','Academia','1012-8255',NULL,3,'Academia : Noticias del Cine Espanol',NULL,NULL,'Freely Accessible General Interest Journals'),(9,'ACTAACADEMICA','Acta Academica','0587-2405',NULL,3,'Acta Académica','1017-7507',NULL,'Educator\'s Reference Complete'),(10,'ACTAACADEMICA','Acta Academica','0587-2405',NULL,3,'Acta Académica','1017-7507',NULL,'Educator\'s Reference Complete'),(11,'ACTAACADEMICA','Acta Academica','0587-2405',NULL,3,'Acta Académica','1017-7507',NULL,'Informe Academico'),(12,'ACTAACADEMICA','Acta Academica','0587-2405',NULL,3,'Acta Académica','1017-7507',NULL,'Informe Academico'),(14,'ACTACRYSTALLOGRAPHICA','Acta crystallographica. Section C, Structural chemistry','2053-2296',NULL,3,'Acta Crystallographica','0365-110X',NULL,'Memorial Library\'s Print Holdings'),(15,'ACTACRYSTALLOGRAPHICA','Acta crystallographica. Section C, Structural chemistry','2053-2296',NULL,3,'Acta crystallographica. Section F, Structural biology communications',NULL,'2053-230X','PubMed Central'),(16,'ACTACRYSTALLOGRAPHICA','Acta crystallographica. Section C, Structural chemistry','2053-2296',NULL,3,'Acta Crystallographica: Section D (Wiley-Blackwell)','0907-4449','1399-0047','Academic Search Premier'),(17,'ACTACRYSTALLOGRAPHICA','Acta crystallographica. Section C, Structural chemistry','2053-2296',NULL,3,'Acta Crystallographica: Section D (Wiley-Blackwell)','0907-4449','1399-0047','MegaFILE'),(27,'ACTAONCOLOGICA','Acta Oncologica','0284-186X','1651-226X',3,'Acta oncologica. Supplement','1100-1704',NULL,'Academic Search Premier'),(28,'ACTAONCOLOGICA','Acta Oncologica','0284-186X','1651-226X',3,'Acta oncologica. Supplement','1100-1704',NULL,'MegaFILE'),(29,'ACTAORIENTALIA','Acta Orientalia','0001-6446','1588-2667',3,'Acta orientalia','0001-6438',NULL,'Expanded Academic ASAP'),(30,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','Academic Search Premier'),(31,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','CINAHL Plus with Full Text'),(32,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','Consumer Health Complete'),(33,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','Health Source: Nursing/Academic Edition'),(34,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','MegaFILE'),(35,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','SPORTDiscus with Full Text'),(36,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','Freely Accessible Science Journals'),(37,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','Academic Search Premier'),(38,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','CINAHL Plus with Full Text'),(39,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','Consumer Health Complete'),(40,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','Directory of Open Access Journals'),(41,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','Health Source: Nursing/Academic Edition'),(42,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','MegaFILE'),(43,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','PubMed Central'),(44,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',0,'Acta orthopaedica','1745-3674','1745-3682','SPORTDiscus with Full Text'),(45,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta oto-laryngologica','0365-5237','1651-2464','Memorial Library\'s Print Holdings'),(46,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta Oto-Laryngologica (Supplement)','0365-5237','1651-2464','Academic Search Premier'),(47,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta Oto-Laryngologica (Supplement)','0365-5237','1651-2464','CINAHL Plus with Full Text'),(48,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta Oto-Laryngologica (Supplement)','0365-5237','1651-2464','Consumer Health Complete'),(49,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta Oto-Laryngologica (Supplement)','0365-5237','1651-2464','Health Source: Nursing/Academic Edition'),(50,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta Oto-Laryngologica (Supplement)','0365-5237','1651-2464','MegaFILE'),(52,'ACTAPSYCHIATRICASCANDINAVICA','Acta Psychiatrica Scandinavica','1600-0447','0001-690X',3,'ACTA PSYCHIATRICA SCANDINAVICA. Supplementum','0065-1591','1600-5473','Academic Search Premier'),(53,'ACTAPSYCHIATRICASCANDINAVICA','Acta Psychiatrica Scandinavica','1600-0447','0001-690X',1,'ACTA PSYCHIATRICA SCANDINAVICA. Supplementum','0065-1591','1600-5473','MegaFILE'),(56,'ACTASOCIOLOGICA','Acta Sociologica','0001-6993','1502-3869',3,'Acta Sociológica (México)','0186-6028',NULL,'ScienceDirect Open Access Titles'),(58,'ACTAVETERINARIASCANDINAVICA','Acta Veterinaria Scandinavica','0044-605X',NULL,3,'Acta veterinaria Scandinavica. Supplementum','0065-1699',NULL,'BioMedCentral'),(66,'ADVANCESINMATHEMATICALPHYSICS','Advances in Mathematical Physics','1687-9120','1687-9139',1,'Advances in Mathematical Physics',NULL,NULL,'Freely Accessible Journals'),(71,'AFRICA','Africa','0001-9720',NULL,2,'Africa',NULL,NULL,'PressReader'),(72,'AFRICA','Africa','0001-9720',NULL,3,'Africa: rivista trimestrale di studi e documentazione dell\'Istituto Italiano per l\'Africa e l\'Oriente','0001-9747',NULL,'JSTOR Arts & Sciences IX'),(77,'AGE','Age','0161-9152',NULL,3,'Age (Melbourne, Australia)',NULL,'0312-6307','Opposing Viewpoints In Context'),(78,'AGE','Age','0161-9152',NULL,3,'Age (Melbourne, Australia)',NULL,'0312-6307','Student Resources In Context'),(79,'AGING','Aging','1945-4589','0002-0966',3,'Aging : GAO activities in fiscal year',NULL,NULL,'U.S. Government Documents'),(80,'AGORA','Agora','1516-1498',NULL,2,'Agora',NULL,NULL,'Freely Accessible Arts & Humanities Journals'),(81,'AGORA','Agora','1516-1498',NULL,3,'AGORA','0044-6726',NULL,'Education Source'),(82,'AGORA','Agora','1516-1498',NULL,3,'AGORA','0044-6726',NULL,'PressReader'),(83,'AGORA','Agora','1516-1498',NULL,3,'Agora (Lynchburg, Va.)','1059-2989',NULL,'Freely Accessible Arts & Humanities Journals'),(84,'AGORA','Agora','1516-1498',NULL,3,'Ágora: Estudos Clássicos em Debate','0874-5498',NULL,'Humanities Source'),(85,'AGRICULTURALECONOMICS','Agricultural Economics','0139-570X',NULL,3,'Agricultural Economics','0169-5150','1574-0862','Backfile Package - Economics, Econometrics and Finance including Supplement 1 [YUT]'),(86,'AGRICULTURALECONOMICS','Agricultural Economics','0139-570X',NULL,3,'Agricultural Economics','0169-5150','1574-0862','ScienceDirect Journals'),(87,'AGRICULTURALECONOMICS','Agricultural Economics','0139-570X',NULL,3,'Agricultural Economics','0169-5150','1574-0862','Wiley-Blackwell Full Collection'),(88,'AGRICULTURALECONOMICSREVIEW','Agricultural Economics Review','1109-2580',NULL,1,'AGRICULTURAL ECONOMICS REVIEW',NULL,NULL,'ABI/INFORM Collection'),(89,'AGRICULTURE','Agriculture','0551-3677','1338-4376',2,'Agriculture',NULL,NULL,'PressReader'),(93,'ALCOHOLISM','Alcoholism','0002-502X',NULL,3,'Alcoholism: clinical and experimental research','0145-6008','1530-0277','Wiley-Blackwell Full Collection'),(94,'ALCOHOLISM','Alcoholism: Clinical and Experimental Research','1530-0277','0145-6008',3,'Alcoholism','0002-502X',NULL,'Criminal Justice Database'),(95,'ALCOHOLISM','Alcoholism: Clinical and Experimental Research','1530-0277','0145-6008',3,'Alcoholism','0002-502X',NULL,'Psychology Database'),(96,'ALEA','Alea','1980-0436',NULL,3,'Alea: Estudos Neolatinos','1517-106X',NULL,'Directory of Open Access Journals'),(97,'ALEA','Alea','1980-0436',NULL,3,'Alea: Estudos Neolatinos','1517-106X',NULL,'Informe Academico'),(98,'ALLERGY','Allergy: European Journal of Allergy and Clinical Immunology','0105-4538','1398-9995',3,'Allergy. Supplement','0108-1675',NULL,'Wiley-Blackwell Full Collection'),(99,'ALTERNATIVES','Alternatives','0304-3754',NULL,3,'Alternatives','0002-6638',NULL,'Educator\'s Reference Complete'),(100,'ALTERNATIVES','Alternatives','0304-3754',NULL,3,'Alternatives (CPR Institute for Dispute Resolution)','2470-1947',NULL,'Wiley-Blackwell Full Collection'),(101,'ALTERNATIVES','Alternatives','0304-3754',NULL,3,'Alternatives (Peterborough, Ont.)','0002-6638',NULL,'Alt-PressWatch'),(102,'ALTERNATIVES','Alternatives','0304-3754',NULL,3,'Alternatives: Turkish Journal of International Relations',NULL,'1303-5525','Academic Search Premier'),(103,'ALTERNATIVES','Alternatives','0304-3754',NULL,3,'Alternatives: Turkish Journal of International Relations',NULL,'1303-5525','MegaFILE'),(104,'ALZHEIMERSANDDEMENTIA','Alzheimer\'s and Dementia','1552-5260','1552-5279',1,'Alzheimer\'s & Dementia : Diagnosis, Assessment & Disease Monitoring',NULL,'2352-8729','PubMed Central'),(105,'ALZHEIMERSANDDEMENTIA','Alzheimer\'s and Dementia','1552-5260','1552-5279',1,'Alzheimer\'s & Dementia: Diagnosis, Assessment & Disease Monitoring',NULL,'2352-8729','ScienceDirect Open Access Titles'),(106,'ALZHEIMERSANDDEMENTIA','Alzheimer\'s and Dementia','1552-5260','1552-5279',1,'Alzheimer\'s & Dementia: Translational Research & Clinical Interventions',NULL,'2352-8737','ScienceDirect Open Access Titles'),(107,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal. Economic Policy','1945-7731','1945-774X','ABI/INFORM Collection'),(108,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal. Macroeconomics','1945-7707','1945-7715','ABI/INFORM Collection'),(109,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal. Microeconomics','1945-7669','1945-7685','ABI/INFORM Collection'),(110,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','American Economic Association Web'),(111,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','JSTOR Arts & Sciences VI'),(112,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','American Economic Association Web'),(113,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','JSTOR Arts & Sciences VI'),(114,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','American Economic Association Web'),(115,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','JSTOR Arts & Sciences VI'),(116,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal. Applied Economics','1945-7782','1945-7790','ABI/INFORM Collection'),(117,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal. Macroeconomics','1945-7707','1945-7715','ABI/INFORM Collection'),(118,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal. Microeconomics','1945-7669','1945-7685','ABI/INFORM Collection'),(119,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','American Economic Association Web'),(120,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','JSTOR Arts & Sciences VI'),(121,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','American Economic Association Web'),(122,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','JSTOR Arts & Sciences VI'),(123,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','American Economic Association Web'),(124,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','JSTOR Arts & Sciences VI'),(125,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal. Applied Economics','1945-7782','1945-7790','ABI/INFORM Collection'),(126,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal. Economic Policy','1945-7731','1945-774X','ABI/INFORM Collection'),(127,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal. Microeconomics','1945-7669','1945-7685','ABI/INFORM Collection'),(128,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','American Economic Association Web'),(129,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','JSTOR Arts & Sciences VI'),(130,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','American Economic Association Web'),(131,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','`'),(132,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','American Economic Association Web'),(133,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','JSTOR Arts & Sciences VI'),(134,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal. Applied Economics','1945-7782','1945-7790','ABI/INFORM Collection'),(135,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal. Economic Policy','1945-7731','1945-774X','ABI/INFORM Collection'),(136,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal. Macroeconomics','1945-7707','1945-7715','ABI/INFORM Collection'),(137,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','American Economic Association Web'),(138,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','JSTOR Arts & Sciences VI'),(139,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','American Economic Association Web'),(140,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','JSTOR Arts & Sciences VI'),(141,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','American Economic Association Web'),(142,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','JSTOR Arts & Sciences VI'),(143,'AMERICANECONOMICREVIEW','American Economic Review','0002-8282',NULL,3,'American Economic Review: Papers and Proceedings',NULL,NULL,'American Economic Association Web'),(145,'AMERICANJOURNALOFEDUCATION','American Journal of Education','1549-6511','0195-6744',3,'American journal of education (Hartford, Conn.)','1077-7032',NULL,'Memorial Library\'s Print Holdings');
/*!40000 ALTER TABLE `base_report_gt_zero` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017-09-26 14:19:26






-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: localhost Database: test
-- ------------------------------------------------------
-- Server version 5.7.19-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `master_data`
--

DROP TABLE IF EXISTS `master_data`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `master_data` (
`master_data_id` int(11) NOT NULL AUTO_INCREMENT,
`StandardTitle` varchar(255) DEFAULT NULL,
`Title_sci` varchar(255) DEFAULT NULL,
`ISSN1` varchar(12) DEFAULT NULL,
`ISSN2` varchar(12) DEFAULT NULL,
`CC` int(11) NOT NULL,
`Title` varchar(255) DEFAULT NULL,
`ISSN` varchar(12) DEFAULT NULL,
`eISSN` varchar(12) DEFAULT NULL,
`Databas` varchar(255) DEFAULT NULL,
PRIMARY KEY (`master_data_id`),
KEY `CC_index` (`CC`)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_data`
--

LOCK TABLES `master_data` WRITE;
/*!40000 ALTER TABLE `master_data` DISABLE KEYS */;
INSERT INTO `master_data` VALUES (1,'3L','3L: Language, Linguistics, Literature','0128-5157',NULL,0,'3L: Southeast Asian Journal of English Language Studies',NULL,NULL,'Education Source'),(2,'ACADEMIA','Academia','1012-8255',NULL,3,'Academia : Noticias del Cine Espanol',NULL,NULL,'Freely Accessible General Interest Journals'),(3,'ACADEMICJOURNALOFMANUFACTURINGENGINEERING','Academic Journal of Manufacturing Engineering','1583-7904',NULL,0,'Academic Journal of Manufacturing Engineering',NULL,NULL,'Applied Science & Technology Source'),(4,'ACCOUNTINGAUDITINGANDACCOUNTABILITYJOURNAL','Accounting, Auditing and Accountability Journal','0951-3574',NULL,0,'Accounting, auditing & accountability journal','1368-0668','1758-4205','ABI/INFORM Collection'),(5,'ACCOUNTINGAUDITINGANDACCOUNTABILITYJOURNAL','Accounting, Auditing and Accountability Journal','0951-3574',NULL,0,'Accounting, auditing & accountability journal','1368-0668','1758-4205','Emerald Management 120'),(6,'ACMIEEEINTERNATIONALCONFERENCEONHUMANROBOTINTERACTION','ACM/IEEE International Conference on Human-Robot Interaction','2167-2148',NULL,0,'ACM/IEEE International Conference on Human-Robot Interaction',NULL,NULL,'Applied Science & Technology Source'),(7,'ACORN','ACORN','1448-7535',NULL,0,'ACORN: the journal of perioperative nursing in Australia','1031-1017',NULL,'CINAHL Plus with Full Text'),(8,'ACSCATALYSIS','ACS Catalysis','2155-5435',NULL,0,'ACS CATALYSIS',NULL,NULL,'ACS Publications'),(9,'ACTAACADEMICA','Acta Academica','0587-2405',NULL,3,'Acta Académica','1017-7507',NULL,'Educator\'s Reference Complete'),(10,'ACTAACADEMICA','Acta Academica','0587-2405',NULL,3,'Acta Académica','1017-7507',NULL,'Educator\'s Reference Complete'),(11,'ACTAACADEMICA','Acta Academica','0587-2405',NULL,3,'Acta Académica','1017-7507',NULL,'Informe Academico'),(12,'ACTAACADEMICA','Acta Academica','0587-2405',NULL,3,'Acta Académica','1017-7507',NULL,'Informe Academico'),(13,'ACTAAGRICULTURAESLOVENICA','Acta Agriculturae Slovenica','1581-9175',NULL,0,'ACTA AGRICULTURAE SLOVENICA',NULL,'1854-1941','Directory of Open Access Journals'),(14,'ACTACRYSTALLOGRAPHICA','Acta crystallographica. Section C, Structural chemistry','2053-2296',NULL,3,'Acta Crystallographica','0365-110X',NULL,'Memorial Library\'s Print Holdings'),(15,'ACTACRYSTALLOGRAPHICA','Acta crystallographica. Section C, Structural chemistry','2053-2296',NULL,3,'Acta crystallographica. Section F, Structural biology communications',NULL,'2053-230X','PubMed Central'),(16,'ACTACRYSTALLOGRAPHICA','Acta crystallographica. Section C, Structural chemistry','2053-2296',NULL,3,'Acta Crystallographica: Section D (Wiley-Blackwell)','0907-4449','1399-0047','Academic Search Premier'),(17,'ACTACRYSTALLOGRAPHICA','Acta crystallographica. Section C, Structural chemistry','2053-2296',NULL,3,'Acta Crystallographica: Section D (Wiley-Blackwell)','0907-4449','1399-0047','MegaFILE'),(18,'ACTACRYSTALLOGRAPHICASECTIONA','Acta Crystallographica Section A: Foundations and Advances','2053-2733',NULL,0,'ACTA CRYSTALLOGRAPHICA SECTION A','0108-7673','1600-5724','Wiley-Blackwell Full Collection'),(19,'ACTACRYSTALLOGRAPHICASECTIONB','Acta Crystallographica Section B: Structural Science, Crystal Engineering and Materials','2052-5206','2052-5192',0,'ACTA CRYSTALLOGRAPHICA SECTION B','0108-7681','1600-5740','Wiley-Blackwell Full Collection'),(20,'ACTACRYSTALLOGRAPHICASECTIONE','Acta Crystallographica Section E: Structure Reports Online','1600-5368',NULL,0,'Acta Crystallographica Section E: Crystallographic Communications',NULL,'2056-9890','PubMed Central'),(21,'ACTACRYSTALLOGRAPHICASECTIONF','Acta Crystallographica Section F: Structural Biology Communications','2053-230X',NULL,0,'Acta Crystallographica Section F',NULL,'1744-3091','Wiley-Blackwell Full Collection'),(22,'ACTACRYSTALLOGRAPHICASECTIONF','Acta Crystallographica Section F: Structural Biology Communications','2053-230X',NULL,0,'Acta Crystallographica Section F: Structural Biology and Crystallization Communications',NULL,'1744-3091','PubMed Central'),(23,'ACTAECOLOGICASINICA','Acta Ecologica Sinica','1000-0933',NULL,0,'Acta Ecologica Sinica',NULL,'1872-2032','ScienceDirect Freedom Collection 2017'),(24,'ACTAMATHEMATICAUNIVERSITATISCOMENIANAE','Acta Mathematica Universitatis Comenianae','0862-9544',NULL,0,'ACTA MATHEMATICA UNIVERSITATIS COMENIANAE','0231-6986','1336-0310','Electronic Library of Mathematics'),(25,'ACTAMATHEMATICAUNIVERSITATISCOMENIANAE','Acta Mathematica Universitatis Comenianae','0862-9544',NULL,0,'ACTA MATHEMATICA UNIVERSITATIS COMENIANAE','0231-6986','1336-0310','Freely Accessible Journals'),(26,'ACTAMATHEMATICAUNIVERSITATISCOMENIANAE','Acta Mathematica Universitatis Comenianae','0862-9544',NULL,0,'ACTA MATHEMATICA UNIVERSITATIS COMENIANAE','0231-6986','1336-0310','Freely Accessible Science Journals'),(27,'ACTAONCOLOGICA','Acta Oncologica','0284-186X','1651-226X',3,'Acta oncologica. Supplement','1100-1704',NULL,'Academic Search Premier'),(28,'ACTAONCOLOGICA','Acta Oncologica','0284-186X','1651-226X',3,'Acta oncologica. Supplement','1100-1704',NULL,'MegaFILE'),(29,'ACTAORIENTALIA','Acta Orientalia','0001-6446','1588-2667',3,'Acta orientalia','0001-6438',NULL,'Expanded Academic ASAP'),(30,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','Academic Search Premier'),(31,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','CINAHL Plus with Full Text'),(32,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','Consumer Health Complete'),(33,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','Health Source: Nursing/Academic Edition'),(34,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','MegaFILE'),(35,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','SPORTDiscus with Full Text'),(36,'ACTAORTHOPAEDICA','Acta Orthopaedica','1745-3674','1745-3682',3,'Acta Orthopaedica (Supplement)','1745-3690','1745-3704','Freely Accessible Science Journals'),(37,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','Academic Search Premier'),(38,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','CINAHL Plus with Full Text'),(39,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','Consumer Health Complete'),(40,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','Directory of Open Access Journals'),(41,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','Health Source: Nursing/Academic Edition'),(42,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','MegaFILE'),(43,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','PubMed Central'),(44,'ACTAORTHOPAEDICA','Acta orthopaedica. Supplementum','1745-3690','1745-3704',3,'Acta orthopaedica','1745-3674','1745-3682','SPORTDiscus with Full Text'),(45,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta oto-laryngologica','0365-5237','1651-2464','Memorial Library\'s Print Holdings'),(46,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta Oto-Laryngologica (Supplement)','0365-5237','1651-2464','Academic Search Premier'),(47,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta Oto-Laryngologica (Supplement)','0365-5237','1651-2464','CINAHL Plus with Full Text'),(48,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta Oto-Laryngologica (Supplement)','0365-5237','1651-2464','Consumer Health Complete'),(49,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta Oto-Laryngologica (Supplement)','0365-5237','1651-2464','Health Source: Nursing/Academic Edition'),(50,'ACTAOTOLARYNGOLOGICA','Acta Oto-Laryngologica','0001-6489',NULL,3,'Acta Oto-Laryngologica (Supplement)','0365-5237','1651-2464','MegaFILE'),(51,'ACTAPHARMACEUTICA','Acta Pharmaceutica','1330-0075',NULL,0,'Acta Pharmaceutica',NULL,NULL,'Directory of Open Access Journals'),(52,'ACTAPSYCHIATRICASCANDINAVICA','Acta Psychiatrica Scandinavica','1600-0447','0001-690X',3,'ACTA PSYCHIATRICA SCANDINAVICA. Supplementum','0065-1591','1600-5473','Academic Search Premier'),(53,'ACTAPSYCHIATRICASCANDINAVICA','Acta Psychiatrica Scandinavica','1600-0447','0001-690X',3,'ACTA PSYCHIATRICA SCANDINAVICA. Supplementum','0065-1591','1600-5473','MegaFILE'),(54,'ACTASDERMOSIFILIOGRAFICAS','Actas Dermo-Sifiliograficas','0001-7310','1578-2190',0,'Actas Dermo-Sifiliográficas (English Edition)',NULL,NULL,'ScienceDirect Freedom Collection 2017'),(55,'ACTASDERMOSIFILIOGRAFICAS','Actas Dermo-Sifiliograficas','0001-7310','1578-2190',0,'Actas Dermo-Sifiliográficas (English Edition)',NULL,'2173-5778','ScienceDirect Freedom Collection 2016'),(56,'ACTASOCIOLOGICA','Acta Sociologica','0001-6993','1502-3869',3,'Acta Sociológica (México)','0186-6028',NULL,'ScienceDirect Open Access Titles'),(57,'ACTASUROLOGICASESPANOLAS','Actas Urologicas Espanolas','0210-4806',NULL,0,'Actas Urológicas Españolas (English Edition)',NULL,'2173-5786','ScienceDirect Freedom Collection 2017'),(58,'ACTAVETERINARIASCANDINAVICA','Acta Veterinaria Scandinavica','0044-605X',NULL,3,'Acta veterinaria Scandinavica. Supplementum','0065-1699',NULL,'BioMedCentral'),(59,'ADMINISTRATIESIMANAGEMENTPUBLIC','Administratie si Management Public','1583-9583',NULL,0,'Administratie si Management Public',NULL,NULL,'ABI/INFORM Collection'),(60,'ADOLESCENTMEDICINE','Adolescent Medicine: State of the Art Reviews','1934-4287',NULL,0,'Adolescent medicine (Philadelphia, Pa.)','1041-3499','1545-0058','Nursing & Allied Health Database'),(61,'ADVANCESINGEOSCIENCES','Advances in Geosciences','1680-7340',NULL,0,'ADVANCES IN GEOSCIENCES',NULL,'1680-7359','Directory of Open Access Journals'),(62,'ADVANCESINHIGHENERGYPHYSICS','Advances in High Energy Physics','1687-7357',NULL,0,'ADVANCES IN HIGH ENERGY PHYSICS',NULL,'1687-7365','Directory of Open Access Journals'),(63,'ADVANCESINHIGHENERGYPHYSICS','Advances in High Energy Physics','1687-7357',NULL,0,'ADVANCES IN HIGH ENERGY PHYSICS',NULL,'1687-7365','Expanded Academic ASAP'),(64,'ADVANCESINHIGHENERGYPHYSICS','Advances in High Energy Physics','1687-7357',NULL,0,'ADVANCES IN HIGH ENERGY PHYSICS',NULL,'1687-7365','General Science Collection'),(65,'ADVANCESINLIFECOURSERESEARCH','Advances in Life Course Research','1040-2608',NULL,0,'ADVANCES IN LIFE COURSE RESEARCH','1569-4909','1879-6974','ScienceDirect Freedom Collection 2017'),(66,'ADVANCESINMATHEMATICALPHYSICS','Advances in Mathematical Physics','1687-9120','1687-9139',1,'Advances in Mathematical Physics',NULL,NULL,'Freely Accessible Journals'),(67,'ADVANCESINPOWERELECTRONICS','Advances in Power Electronics','2090-181X',NULL,0,'ADVANCES IN POWER ELECTRONICS',NULL,'2090-1828','Applied Science & Technology Source'),(68,'ADVANCESINPOWERELECTRONICS','Advances in Power Electronics','2090-181X',NULL,0,'ADVANCES IN POWER ELECTRONICS',NULL,'2090-1828','Expanded Academic ASAP'),(69,'ADVANCESINRADIOSCIENCE','Advances in Radio Science','1684-9965',NULL,0,'ADVANCES IN RADIO SCIENCE',NULL,'1684-9973','Directory of Open Access Journals'),(70,'ADVANCESINTRIBOLOGY','Advances in Tribology','1687-5915',NULL,0,'ADVANCES IN TRIBOLOGY',NULL,'1687-5923','Applied Science & Technology Source'),(71,'AFRICA','Africa','0001-9720',NULL,2,'Africa',NULL,NULL,'PressReader'),(72,'AFRICA','Africa','0001-9720',NULL,3,'Africa: rivista trimestrale di studi e documentazione dell\'Istituto Italiano per l\'Africa e l\'Oriente','0001-9747',NULL,'JSTOR Arts & Sciences IX'),(73,'AFRICANJOURNALOFINFECTIOUSDISEASES','African Journal of Infectious Diseases','2006-0165',NULL,0,'African Journal of Infectious Diseases',NULL,NULL,'PubMed Central'),(74,'AGE','Age','0161-9152',NULL,0,'Age (Dordrecht, Netherlands)','2452-0756','1574-4647','ABI/INFORM Collection'),(75,'AGE','Age','0161-9152',NULL,0,'Age (Dordrecht, Netherlands)','2452-0756','1574-4647','Nursing & Allied Health Database'),(76,'AGE','Age','0161-9152',NULL,0,'Age (Dordrecht, Netherlands)','2452-0756','1574-4647','PubMed Central'),(77,'AGE','Age','0161-9152',NULL,3,'Age (Melbourne, Australia)',NULL,'0312-6307','Opposing Viewpoints In Context'),(78,'AGE','Age','0161-9152',NULL,3,'Age (Melbourne, Australia)',NULL,'0312-6307','Student Resources In Context'),(79,'AGING','Aging','1945-4589','0002-0966',3,'Aging : GAO activities in fiscal year',NULL,NULL,'U.S. Government Documents'),(80,'AGORA','Agora','1516-1498',NULL,2,'Agora',NULL,NULL,'Freely Accessible Arts & Humanities Journals'),(81,'AGORA','Agora','1516-1498',NULL,3,'AGORA','0044-6726',NULL,'Education Source'),(82,'AGORA','Agora','1516-1498',NULL,3,'AGORA','0044-6726',NULL,'PressReader'),(83,'AGORA','Agora','1516-1498',NULL,3,'Agora (Lynchburg, Va.)','1059-2989',NULL,'Freely Accessible Arts & Humanities Journals'),(84,'AGORA','Agora','1516-1498',NULL,3,'Ágora: Estudos Clássicos em Debate','0874-5498',NULL,'Humanities Source'),(85,'AGRICULTURALECONOMICS','Agricultural Economics','0139-570X',NULL,3,'Agricultural Economics','0169-5150','1574-0862','Backfile Package - Economics, Econometrics and Finance including Supplement 1 [YUT]'),(86,'AGRICULTURALECONOMICS','Agricultural Economics','0139-570X',NULL,3,'Agricultural Economics','0169-5150','1574-0862','ScienceDirect Journals'),(87,'AGRICULTURALECONOMICS','Agricultural Economics','0139-570X',NULL,3,'Agricultural Economics','0169-5150','1574-0862','Wiley-Blackwell Full Collection'),(88,'AGRICULTURALECONOMICSREVIEW','Agricultural Economics Review','1109-2580',NULL,1,'AGRICULTURAL ECONOMICS REVIEW',NULL,NULL,'ABI/INFORM Collection'),(89,'AGRICULTURE','Agriculture','0551-3677','1338-4376',2,'Agriculture',NULL,NULL,'PressReader'),(90,'AIJJOURNALOFTECHNOLOGYANDDESIGN','AIJ Journal of Technology and Design','1341-9463',NULL,0,'AIJ Journal of Technology and Design',NULL,'1881-8188','J-STAGE (Japan Science & Technology Information Aggregator, Electronic) Freely Available Titles - English'),(91,'AINSHAMSENGINEERINGJOURNAL','Ain Shams Engineering Journal','2090-4479',NULL,0,'AIN SHAMS ENGINEERING JOURNAL',NULL,NULL,'ScienceDirect Open Access Titles'),(92,'AKCEINTERNATIONALJOURNALOFGRAPHSANDCOMBINATORICS','AKCE International Journal of Graphs and Combinatorics','0972-8600',NULL,0,'AKCE International Journal of Graphs and Combinatorics',NULL,NULL,'ScienceDirect Open Access Titles'),(93,'ALCOHOLISM','Alcoholism','0002-502X',NULL,3,'Alcoholism: clinical and experimental research','0145-6008','1530-0277','Wiley-Blackwell Full Collection'),(94,'ALCOHOLISM','Alcoholism: Clinical and Experimental Research','1530-0277','0145-6008',3,'Alcoholism','0002-502X',NULL,'Criminal Justice Database'),(95,'ALCOHOLISM','Alcoholism: Clinical and Experimental Research','1530-0277','0145-6008',3,'Alcoholism','0002-502X',NULL,'Psychology Database'),(96,'ALEA','Alea','1980-0436',NULL,3,'Alea: Estudos Neolatinos','1517-106X',NULL,'Directory of Open Access Journals'),(97,'ALEA','Alea','1980-0436',NULL,3,'Alea: Estudos Neolatinos','1517-106X',NULL,'Informe Academico'),(98,'ALLERGY','Allergy: European Journal of Allergy and Clinical Immunology','0105-4538','1398-9995',3,'Allergy. Supplement','0108-1675',NULL,'Wiley-Blackwell Full Collection'),(99,'ALTERNATIVES','Alternatives','0304-3754',NULL,3,'Alternatives','0002-6638',NULL,'Educator\'s Reference Complete'),(100,'ALTERNATIVES','Alternatives','0304-3754',NULL,3,'Alternatives (CPR Institute for Dispute Resolution)','2470-1947',NULL,'Wiley-Blackwell Full Collection'),(101,'ALTERNATIVES','Alternatives','0304-3754',NULL,3,'Alternatives (Peterborough, Ont.)','0002-6638',NULL,'Alt-PressWatch'),(102,'ALTERNATIVES','Alternatives','0304-3754',NULL,3,'Alternatives: Turkish Journal of International Relations',NULL,'1303-5525','Academic Search Premier'),(103,'ALTERNATIVES','Alternatives','0304-3754',NULL,3,'Alternatives: Turkish Journal of International Relations',NULL,'1303-5525','MegaFILE'),(104,'ALZHEIMERSANDDEMENTIA','Alzheimer\'s and Dementia','1552-5260','1552-5279',1,'Alzheimer\'s & Dementia : Diagnosis, Assessment & Disease Monitoring',NULL,'2352-8729','PubMed Central'),(105,'ALZHEIMERSANDDEMENTIA','Alzheimer\'s and Dementia','1552-5260','1552-5279',1,'Alzheimer\'s & Dementia: Diagnosis, Assessment & Disease Monitoring',NULL,'2352-8729','ScienceDirect Open Access Titles'),(106,'ALZHEIMERSANDDEMENTIA','Alzheimer\'s and Dementia','1552-5260','1552-5279',1,'Alzheimer\'s & Dementia: Translational Research & Clinical Interventions',NULL,'2352-8737','ScienceDirect Open Access Titles'),(107,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal. Economic Policy','1945-7731','1945-774X','ABI/INFORM Collection'),(108,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal. Macroeconomics','1945-7707','1945-7715','ABI/INFORM Collection'),(109,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal. Microeconomics','1945-7669','1945-7685','ABI/INFORM Collection'),(110,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','American Economic Association Web'),(111,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','JSTOR Arts & Sciences VI'),(112,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','American Economic Association Web'),(113,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','JSTOR Arts & Sciences VI'),(114,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','American Economic Association Web'),(115,'AMERICANECONOMICJOURNAL','American Economic Journal: Applied Economics','1945-7790','1945-7782',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','JSTOR Arts & Sciences VI'),(116,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal. Applied Economics','1945-7782','1945-7790','ABI/INFORM Collection'),(117,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal. Macroeconomics','1945-7707','1945-7715','ABI/INFORM Collection'),(118,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal. Microeconomics','1945-7669','1945-7685','ABI/INFORM Collection'),(119,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','American Economic Association Web'),(120,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','JSTOR Arts & Sciences VI'),(121,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','American Economic Association Web'),(122,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','JSTOR Arts & Sciences VI'),(123,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','American Economic Association Web'),(124,'AMERICANECONOMICJOURNAL','American Economic Journal: Economic Policy','1945-774X','1945-7731',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','JSTOR Arts & Sciences VI'),(125,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal. Applied Economics','1945-7782','1945-7790','ABI/INFORM Collection'),(126,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal. Economic Policy','1945-7731','1945-774X','ABI/INFORM Collection'),(127,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal. Microeconomics','1945-7669','1945-7685','ABI/INFORM Collection'),(128,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','American Economic Association Web'),(129,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','JSTOR Arts & Sciences VI'),(130,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','American Economic Association Web'),(131,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','`'),(132,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','American Economic Association Web'),(133,'AMERICANECONOMICJOURNAL','American Economic Journal: Macroeconomics','1945-7715','1945-7707',3,'American Economic Journal: Microeconomics','1945-7669','1945-7685','JSTOR Arts & Sciences VI'),(134,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal. Applied Economics','1945-7782','1945-7790','ABI/INFORM Collection'),(135,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal. Economic Policy','1945-7731','1945-774X','ABI/INFORM Collection'),(136,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal. Macroeconomics','1945-7707','1945-7715','ABI/INFORM Collection'),(137,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','American Economic Association Web'),(138,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Applied Economics','1945-7782','1945-7790','JSTOR Arts & Sciences VI'),(139,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','American Economic Association Web'),(140,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Economic Policy','1945-7731','1945-774X','JSTOR Arts & Sciences VI'),(141,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','American Economic Association Web'),(142,'AMERICANECONOMICJOURNAL','American Economic Journal: Microeconomics','1945-7685','1945-7669',3,'American Economic Journal: Macroeconomics','1945-7707','1945-7715','JSTOR Arts & Sciences VI'),(143,'AMERICANECONOMICREVIEW','American Economic Review','0002-8282',NULL,3,'American Economic Review: Papers and Proceedings',NULL,NULL,'American Economic Association Web'),(144,'AMERICANJOURNALOFCANCERRESEARCH','American Journal of Cancer Research','2156-6976',NULL,0,'AMERICAN JOURNAL OF CANCER RESEARCH',NULL,NULL,'PubMed Central'),(145,'AMERICANJOURNALOFEDUCATION','American Journal of Education','1549-6511','0195-6744',3,'American journal of education (Hartford, Conn.)','1077-7032',NULL,'Memorial Library\'s Print Holdings');
/*!40000 ALTER TABLE `master_data` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017-09-26 14:23:15

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Display all the records from table using cursor
715
September 26, 2017 01:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.