Create two small stored procedures Mysql 8

$10-30 USD

Completed

Posted

over 4 years ago

$10-30 USD

Paid on delivery

(1) Do not alter the columns (and if You have to, ask me first) (2) With tabel MyShapes; For all rows, calculate from the Shape column the centroid with proper Mysql8 function. Put result in column "center" as a point. (3) From the MyPoints table, fill in 10 random numbers within the scope of shape column in myshape. (4) Match the numbers against the shape column in myshapes. If hit, put the ID of that row in column shape. The task is not to make this calculation but to create two stored procedures.

MySQL

Database Programming

SQL

Project ID: 23574874

About the project

3 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

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:

@AhsamDev

Hi I am Ahsam I have might experience in managing databases mysql, sql and oracle. I can made these 2 stored procedure for you within 3-4 hours.I am new to Feelancer but not less experience done. I can make the procedure fast and make your query optimized one.

$20 USD in 1 day

5.0

(1 review)

0.6

3 freelancers are bidding on average $33 USD for this job

@aap31374

I am currently working on mysql procedure optimization project. I have more then 10 years of experience in SQL Server, mySql, postgres databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I have attached my profile. I am immediate available to join. Please help me if you can find any remote or full time work for me. I am ready to work any time zone. Thanks Anil Patel

$55 USD in 1 day