Find Jobs
Hire Freelancers

Develop MySQL "nested stored" procedure using a cursor to loop through a table

$30-250 USD

Completed
Posted almost 10 years ago

$30-250 USD

Paid on delivery
I have a MySQL table which contains a table with n article titles. I now want to find a number of "similar" titles for each of these titles. I have developed a MySQL procedure which gives me a list of similar titles for ONE title/row. I now need someone who can further develop this so that a procedure loops through the table and creates another table which contains the ID ("N") of the original title and 15 similar IDs ("N1"). At the end this table should, consequently, contain two columns (N and N1) with n*15 rows. For this project no knowledge of PHP is required since this procedure only needs to run in MySQL to create a table which will be exported for use in other software. I will provide a sample MySQL database/table with 5000 rows and the procedure that works for a single row.
Project ID: 5892117

About the project

11 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, Let me introduce myself as an expert in Database design and analysis. I have worked on several database technologies like MS Access , SQL Server, Oracle,MySQL etc. I have more than 10 years of experience to my credit. I have worked extensively on creation of queries, stored procedures etc. in MySQL. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$100 USD in 5 days
4.5 (130 reviews)
5.9
5.9
11 freelancers are bidding on average $137 USD for this job
User Avatar
Sure sir, When can i start ?..........................................................................................................
$157 USD in 3 days
4.9 (7 reviews)
5.7
5.7
User Avatar
I am a database expert and have vast knowledge of MySQL and Oracle database. I have written plenty of queries and pl/sql procedures. I have more than 4 years of experience. I can do this job and give you a very good solution
$200 USD in 3 days
4.8 (8 reviews)
4.4
4.4
User Avatar
Dear sir I have 3+ years experience in this please do share details and do discuss I can show the work done before Regards Vijay websolution
$144 USD in 3 days
4.9 (9 reviews)
3.6
3.6
User Avatar
Hello, We’re Tegonity. We have specialized, and well experienced MySQL Experts. We came up to your project description and We’re interested to assist you on the respective project. ------------------------------- FEATURES Working with US ---- (1) Quick Delivery --- (2) Multiple Concepts --- (3) Multiple Revision ------------------------------- From the description you provided, We’re sure you are looking for Experts with strong skill in the field with better work experiences. That’s why we evaluate each Project in detail and propose the most appropriate solutions for your Needs and Goals. ------------------------------- To help us understand your needs give us your Project Details. This is the starting point for any of our projects and will help us to understand you and your requirements. The more details you give us, the better we will able to serve you. ------------------------------- For our work, Samples You can check out our portfolio section. Give us a chance to serve you quality work. ------------------------------- If you have Questions and Suggestions please feel free to contact us, Ideas of our Clients will enrich our works. ------------------------------- Regards: - - - - - - - Tegonity
$258 USD in 3 days
5.0 (2 reviews)
1.2
1.2
User Avatar
Hi, Writing SP is my current job, will try to finish it for you by this weekend , cos weekday back to work. Thanks. Waiting for your message
$50 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements. We have right skills to work on this assignment. We are a team of professionals including experienced analysts, designers, project managers, developers and QA people having great expertise in web applications development mainly on core PHP, PHP with open sources (Joomla, Wordpress, Codeigniter, Cake PHP), .NET, Asp.NET, Vb.NET, HTML 5 etc. and mobile applications on ios and Android platform. Our award = superb result = happy client. In a good partnership, good results happen. Good cooking makes good eating!BWe consider our client as our partner. can u provide your email or sky-pe etc for further discussion about the project I am ready to discuss with you with best Regards
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Being a Systems Analyst with over 10 years of experience in IT, I can do the job. SQL queries are one of my specialties. And I am being working with MySQL for almost 8 years. Thanks in Advance
$266 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear sir, I am an experience, professional, reliable PHP/MySql developer. It would be my pleasure to develop the procedure for you Waiting for you reply Kindly, Winston
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, Having more than 7 years of expereience in database management complex query writing, having a good experience in mysql procedures and inner query writings. i can work with you to complete your job with quick manner. ~Rameez.
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of VIETNAM
Singapore, Vietnam
5.0
55
Payment method verified
Member since Oct 27, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.