Create Temporary MySQL Table
1 2 USE reference; 3 4 CREATE TEMPORARY TABLE fulltxt 5 SELECT surname,atitle,title,type,journal,pqid,volume, issn,issue,spage,year 6 FROM citations 7 WHERE volume > 0 8 AND issue > 0 9 AND spage > 0 10 AND issn != '' 11 AND pqid != '' 12 ;