Create Temporary MySQL Table
USE reference; CREATE TEMPORARY TABLE fulltxt SELECT surname,atitle,title,type,journal,pqid,volume, issn,issue,spage,year FROM citations WHERE volume > 0 AND issue > 0 AND spage > 0 AND issn != '' AND pqid != '' ;
DZone Snippets > offspinner > temporary
12388 users tagging and storing useful source code snippets
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
USE reference; CREATE TEMPORARY TABLE fulltxt SELECT surname,atitle,title,type,journal,pqid,volume, issn,issue,spage,year FROM citations WHERE volume > 0 AND issue > 0 AND spage > 0 AND issn != '' AND pqid != '' ;