Find Jobs
Hire Freelancers

Write a mySQL query which creates a View

£20-250 GBP

I përfunduar
Postuar about 5 years ago

£20-250 GBP

Paguhet në dorëzim
I would like someone to write me a mysql subquery which extracts two sets of information from a mySQL database and then presents them side by side. The output should be a mySQL View. Attached you will find [login to view URL] and result.csv. These represent a sample of the database file and the desired output. Things to note in the [login to view URL] file Fields 1 to 5 extract the data for Amazon Buttoned Down-Classic Fit Fields 6 to 10 extract the data for Brooks Brothers-Madison Fit The same information is extracted for both, so I think you will need to change the field names for fields 6 to 10. Brooks Brothers-Madison Fit is not available in a 14 inch collar, so the View needs to show that by inserting "Not available" Amazon Buttoned Down-Classic Fit is not available in a 14.5 and 15.5 inch collar, so the View needs to show that by inserting "Not available" The number of rows should be the union of the collar sizes available for Amazon and Brooks Brothers, so in this case 5 rows for 14 14.5 15 15.5 and 16. Please let me know if you have any questions and include the word turtle in the first line of your response to show you have read the whole of this text. Thanks for your interest. Steven
ID e Projektit: 18798039

Rreth projektit

14 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
turtle Hi Steven, Peter here, the freelancer you hired for the shirt selector project. Thank you for inviting me to bid on this. You can have me construct the MySQL (sub)query to extract something akin to the one showed in result.csv. I'm guessing this will be used within a WordPress plugin, so I'll take steps to ensure the query will have the flexibility to accommodate that, should MySQL allows. Thank you again for inviting me to bid. Regards, Peter
£160 GBP në 5 ditë
5,0 (160 përshtypje)
7,0
7,0
14 freelancers are bidding on average £134 GBP for this job
Avatari i Përdoruesit
Hi There I've excellent programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Programming and Computer project according to 100% accuracy and requirements, with dedicated support. Thanks Farah Saif
£100 GBP në 3 ditë
4,8 (190 përshtypje)
6,4
6,4
Avatari i Përdoruesit
Hi, this looks like something we could help you with. I specialize in: PHP & PHP frameworks such as Laravel, CI, Yii and CakePHP, API development, HTML5, CSS, JavaScript, Bootstrap, MySQL, etc. Before I start, we need short chat to clarify all details. Thank you for your kindly attention. Regards,
£150 GBP në 3 ditë
4,9 (55 përshtypje)
6,5
6,5
Avatari i Përdoruesit
Hi there, I can write this query, and i can start working on it after few hours as this is 3 AM here and i am about to sleep. Please come on the chat to discuss! Thanks
£250 GBP në 3 ditë
4,8 (11 përshtypje)
4,2
4,2
Avatari i Përdoruesit
Hi, ---------------------------------- I am Dmitrii Potapov. I am a senior website developer and software developer. I am interested in your project. Please contact me if you are searching a freelancer who can complete the task. Looking forward to hearing from you. -------------------------------------------- Kind Regards
£150 GBP në 3 ditë
4,5 (5 përshtypje)
4,8
4,8
Avatari i Përdoruesit
Similar PHP projects I've COMPLETED on Freelancer.com: https://www.freelancer.com/projects/javascript/Google-app-Script-16324428/ https://www.freelancer.com/projects/php/Help-turn-Node-function-into/ https://www.freelancer.com/projects/php/Create-small-script-that-creates/ https://www.freelancer.com/projects/php/Consignment-Reports/
£77 GBP në 2 ditë
4,9 (14 përshtypje)
4,0
4,0
Avatari i Përdoruesit
Hi there,I am MySQL expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
£150 GBP në 2 ditë
5,0 (2 përshtypje)
3,4
3,4
Avatari i Përdoruesit
Turtle Hi, I have gone through your description and I am able to do your job in about no time according to the job description. What you will get? * You get standard quality work * You will get technical support(After payment) If you want me to complete your project then please initiate the thread to discuss the details of the project. I am available to work on your project right now. Thanks!!
£150 GBP në 3 ditë
5,0 (4 përshtypje)
2,9
2,9
Avatari i Përdoruesit
Hi, I have been a database developer for 10 years. I have hands-on experience in MySQL also. Hope to hear from you soon. Regards. Huseyin.
£150 GBP në 3 ditë
5,0 (2 përshtypje)
1,6
1,6
Avatari i Përdoruesit
hello sir how are you i hope you are fine i am professional mysql developer and i have years of experience of mysql and php and all that i am am perfect for this type of work sir
£150 GBP në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Turtle! New to this site, but an expert in (My-)SQL.
£111 GBP në 2 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Turtle Will give you the MySql statement so that you can create your own view with a few simple modifications.
£99 GBP në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
hi. I have 8 years experience in mysql, I have project with more than 100.000.000 records in mysql. It would be a great pleasure to work with you.
£81 GBP në 2 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED KINGDOM
London, United Kingdom
5,0
3
Mënyra e pagesës u verifikua
Anëtar që nga qer 16, 2018

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.