Advanced Search

Posted By

bsrinivasan92 on 01/31/12

Tagged

Versions (?)

Last Edited at 01/31/12 12:27pm

Statistics

Viewed 159 times
Favorited by 0 user(s)

beta_tester_database.sql

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.