advanced code snippet search

Posted By

bsrinivasan92 on 01/31/12


Tagged


Versions (?)

beta_tester_database.sql

 / Published in: SQL
 

SQL database

Expand | Embed | Plain Text 
  1. CREATE DATABASE betadata;
  2. USE betadata
  3. CREATE TABLE master_list(
  4. Priority varchar(50),
  5. Date varchar(50),
  6. eMail varchar(50),
  7. First varchar(50),
  8. Last varchar(50),
  9. Team_Member varchar(50),
  10. Given_Beta varchar(50),
  11. Date_Given_Beta varchar(50));
  12. INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) 
  13. VALUES("1","8/13/2009","[email protected]","David","Mad","Team member 1","Yes","8/13/2009");
  14. INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) 
  15. VALUES("1","8/13/2009","[email protected]","Wesley","Snipes","Team member 2","Yes","8/13/2009");
  16. INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) 
  17. VALUES("1","8/13/2009","[email protected]","Kelly","Arch","Team member 3","Yes","8/13/2009");
  18.  
  19. --This is just a sample, there will likely be more rows

Report this snippet  

You need to login to post a comment.