SQL stores result in Temp table


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



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.