Advanced Search

SQL stores result in Temp table

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT camping_rec.user, 
  2.        "CS123" camp,  -- comment
  3.        " " v15       
  4.  FROM camping_rec
  5.   WHERE camp = 'ACE' -- comment
  6.   INTO temp b_0 WITH no log;
  7.  
  8. ...
  9. SELECT * FROM b_0;
  10.  
  11. ...
  12. DROP TABLE b_0;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.