Return to Snippet

Revision: 55247
at January 31, 2012 12:38 by bsrinivasan92


Updated Code
CREATE DATABASE betadata;
use betadata
CREATE TABLE master_list(
Priority varchar(50),
Date varchar(50),
eMail varchar(50),
First varchar(50),
Last varchar(50),
Team_Member varchar(50),
Given_Beta varchar(50),
Date_Given_Beta varchar(50));
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) 
VALUES("1","8/13/2009","[email protected]","David","Mad","Team member 1","Yes","8/13/2009");
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) 
VALUES("1","8/13/2009","[email protected]","Wesley","Snipes","Team member 2","Yes","8/13/2009");
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) 
VALUES("1","8/13/2009","[email protected]","Kelly","Arch","Team member 3","Yes","8/13/2009");

--This is just a sample, there will likely be more rows

Revision: 55246
at January 31, 2012 12:28 by bsrinivasan92


Updated Code
CREATE DATABASE betadata;
use betadata
CREATE TABLE master_list(
Priority varchar(50),
Date varchar(50),
eMail varchar(50),
First varchar(50),
Last varchar(50),
Team_Member varchar(50),
Given_Beta varchar(50),
Date_Given_Beta varchar(50));
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) 
VALUES("1","8/13/2009","[email protected]","David","Matteson","Brent Poole","Yes","8/13/2009");
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) 
VALUES("1","8/13/2009","[email protected]","Blaine","Bartlett","Chris Hewett","Yes","8/13/2009");
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) 
VALUES("1","8/13/2009","[email protected]","Pam","Bartlett","Chris Hewett","Yes","8/13/2009");
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) 
VALUES("1","8/13/2009","[email protected]","Debbie","Daniels","Chris Hewett","Yes","8/13/2009");
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) 
VALUES("1","8/13/2009","[email protected]","Rod","Nichols","Chris Hewett","Yes","8/13/2009");

--This is just a sample, there will likely be more rows

Revision: 55245
at January 31, 2012 12:27 by bsrinivasan92


Initial Code
CREATE DATABASE betadata;
use betadata
CREATE TABLE master_list(
Priority varchar(50),
Date varchar(50),
eMail varchar(50),
First varchar(50),
Last varchar(50),
Team_Member varchar(50),
Given_Beta varchar(50),
Date_Given_Beta varchar(50));
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) VALUES("1","8/13/2009","[email protected]","David","Matteson","Brent Poole","Yes","8/13/2009");
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) VALUES("1","8/13/2009","[email protected]","Blaine","Bartlett","Chris Hewett","Yes","8/13/2009");
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) VALUES("1","8/13/2009","[email protected]","Pam","Bartlett","Chris Hewett","Yes","8/13/2009");
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) VALUES("1","8/13/2009","[email protected]","Debbie","Daniels","Chris Hewett","Yes","8/13/2009");
INSERT INTO master_list(Priority,Date,eMail,First,Last,Team_Member,Given_Beta,Date_Given_Beta) VALUES("1","8/13/2009","[email protected]","Rod","Nichols","Chris Hewett","Yes","8/13/2009");

--This is just a sample, there will likely be more rows

Initial URL


Initial Description
SQL database

Initial Title
beta_tester_database.sql

Initial Tags


Initial Language
SQL