In Progress

Mysql Views to be created

I have 138 Columns with 365 days are rows. Each day any of 138 columns may have some numeric value, I want to create a view so that I can filter or search sales done on specific item (column value) for the year etc. You need to connect to my desktop for accessing the database.

New View should have 3 columns like Date Value Sale Amount

Value Column will have the values of all original column names found in the table.

Example say if original column is like this:

Date program1 program 2

2/2/2018 1000

3/3/2018 1000

4/4/2018 200 200

I want new View to be like this

Date Value Sale_amount

So that I should be able to generate report like show me all sales generated from Program1 etc

Skills: Database Programming, MySQL, SQL

See more: We are after a new website look that matches our new branding. Our style guideline is attached, and you need to use this to guid, do you need grafic designer for new business, do you need a typist for your new business, you are a human resource manager at a marketing company and you need to hire a new marketing analyst write interview in a dialog, i need a design for my new business logo australia, i have a project where you need, hello my data httptarekahmedlancerinfosamplesintroductionindexhtml i am ready to do the project you need samples of what i did b, hello i have lots of images that need to be converted to excel i will provide you a sample and you must ready to start soon new , do you need editing and proof reading, do you need an engineer to design farm attic firestop in ontario, do you need a translator, convert mssql sql file mysql sql file, convert sql file text, mysql views, need help writing sql statements, php mysql sql file script, php mysql sql file read, php mysql sql file, mysql sql file php, mysql views slow

About the Employer:
( 12 reviews ) chennai, India

Project ID: #16694825

Awarded to:

Adan94

Hi, Hope you are doing great. I am data warehousing certified professional and i have work experience of world's Top Data warehouse company "Teradata" .I can easily accomplish this [login to view URL] feel free to contact More

₹850 INR in 1 day
(0 Reviews)
0.0

7 freelancers are bidding on average ₹1093 for this job

ksab

I can help to create the view you want. On your desktop. Thanks

₹850 INR in 2 days
(5 Reviews)
2.3
DSTechPro

A proposal has not yet been provided

₹850 INR in 3 days
(1 Review)
1.0
jdace1231

A proposal has not yet been provided

₹1300 INR in 1 day
(1 Review)
0.2
thiagog94

A proposal has not yet been provided

₹1750 INR in 3 days
(0 Reviews)
0.0
gymboyamit

A proposal has not yet been provided

₹750 INR in 1 day
(0 Reviews)
0.0
Apurba83

A proposal has not yet been provided

₹1300 INR in 1 day
(0 Reviews)
0.0