Untitled

CREATE TABLE Persons

(

P_Id int,

LastName varchar(255),

FirstName varchar(255),

Address varchar(255),

City varchar(255)

)

 

CREATE TABLE appsall (

    id INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,

        url VARCHAR(255),

        name VARCHAR(255),

        price VARCHAR(255),

        browsepath VARCHAR(255),

        cversion VARCHAR(255),

        updated VARCHAR(255),

        released VARCHAR(255),

        size VARCHAR(255),

        sellers VARCHAR(255),

        creviews VARCHAR(255),

        areviews VARCHAR(255),

        stars5 VARCHAR(255),

        stars4 VARCHAR(255),

        stars3 VARCHAR(255),

        stars2 VARCHAR(255),

        stars1 VARCHAR(255),

        stars5a VARCHAR(255),

        stars4a VARCHAR(255),

        stars3a VARCHAR(255),

        stars2a VARCHAR(255),

        stars1a VARCHAR(255)   

)

 

 

Insert into apps(url, name, price, browsepath, cversion, updated, released, size, sellers, creviews,  stars5, stars4, stars3, stars2, stars1, stars5a, stars4a, stars3a, stars2a, stars1a) values

(http://ax.itunes.apple.com/us/app/id324074347,8-9-3 #1,$0.99,/36/6018,1.1 (iOS 3.0 Tested),Aug 24 2009,NA,

 19.8,Genus Corp,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NAis kwery

 

Insert into apps(url, name, price, browsepath, cversion, updated, released, size, sellers, creviews, stars5, stars4, stars3, stars2, stars1, stars5a, stars4a, stars3a, stars2a, stars1a) values('http://ax.itunes.apple.com/us/app/id324074347','8-9-3 #1','$0.99','/36/6018','1.1 (iOS 3.0 Tested)','Aug 24 2009','NA','  19.8','Genus Corp','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA'