Never been to DZone Snippets before?

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

About this user

http://www.rbs.me.uk

« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS 

Create Temporary MySQL Table

// description of your code here

   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  ;
to mysql table query temporary by offspinner on Feb 09, 2006
« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS