Find Jobs
Hire Freelancers

MySQL Database Update Help - read description

$10-30 CAD

Closed
Posted about 4 years ago

$10-30 CAD

Paid on delivery
I am looking for someone to help me modify a database I already have. I have Country, State/Province and Cities. Canada -> Province -> City United States -> State -> City Currently the database is already filled however the states are not in alphetic order and the cities do not belong to the states or provinces. I want to delete the current Cities and put in my own but not sure how to connect them to the states and provinces for the drop down menu. Will be done through screen shots. ASAP by the hour.
Project ID: 23982787

About the project

29 proposals
Remote project
Active 4 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
29 freelancers are bidding on average $32 CAD for this job
User Avatar
Hello, As an expert in MySQL, i am very much interested to help you to do the required update in your tables. Looking forward to have a positive response from you. Thanks
$50 CAD in 1 day
5.0 (216 reviews)
7.4
7.4
User Avatar
Hello, I'm Abu Gosia. I'm interesting your project very well. I'm good in Website Design, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart, C#, .Net, MVC, Angular.js, ASP.NET. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
$25 CAD in 1 day
4.9 (56 reviews)
5.9
5.9
User Avatar
Hi I totally understood your requirement. You said that cities do not belong to the states or provinces but as I can see in city table there is state id present in it. However I can do this so lets discuss further in chat area thanks.
$40 CAD in 1 day
5.0 (56 reviews)
6.0
6.0
User Avatar
Dear Hiring Manager, I went through your project requirements. I am ready to begin immediately & I am quite sure I can modified and arrange it in alphabetical order as you required. I have a team of 6+years experience, I am a Full Stack Developer with Heavy PHP, Mysql, Codeigniter & WordPress Development. I am Specialises in Front and Back end, Windows, Mac and Linux Environment. **Feel free to come, message board.** If you are looking for long-term engagement and a developer to take care of your development needs, I am the one. I will be more than willing to provide references for my clients. Regards, 360 P
$50 CAD in 1 day
4.8 (25 reviews)
5.7
5.7
User Avatar
Hello. I have just read your proposal and I am very interested in your project. I have rich experience in MySQL. I will perfectly complete your project in a short time. If you give me a chance, I will do my best for you. Thank you.
$30 CAD in 1 day
5.0 (5 reviews)
4.8
4.8
User Avatar
Greetings, I'm professional database and BI expert with 12+ years experience. Currently I'm working as Senior DW, BI & DB developer in one of the leader financial corporation. As you can see in my profile page, I have a deep experience of database related projects. I'm top expert. -- Best regards, Davit Dartsimelia Senior BI & SQL Developer
$55 CAD in 1 day
5.0 (4 reviews)
4.4
4.4
User Avatar
Certified SQL expert here, placed in the top 3% of all freelancers globally. Available to complete this for you right away, please check my profile for relevant reviews.
$25 CAD in 1 day
5.0 (6 reviews)
3.3
3.3
User Avatar
Hi, I am oracle certified DBA 9i/10g/11g with more then 21 years of experience as DBA on various platforms. I have worked with financial giants on mission critical databases for Fidelity, JP MORGAN Chase. Besides that I also worked as DBA for British airways, Government of California, Service power, NetApp etc. If you need some one experienced and proven expertise, let me know so that we can communicate further. Gaurav
$20 CAD in 7 days
5.0 (5 reviews)
2.0
2.0
User Avatar
Hi.. I am working from 8 years with sql server and services. Worked with sql server from version sql 2008 r2 to 2017. I am involved in data migration, clustering, always on, stored procedure, views, schema, table , query performance and other activities. I have worked with central and state government projects having one lacs users around and 10 stake holders. worked with database of 1 tb and millions of rows in a table. So worked inquery performance, sql profiler also.
$15 CAD in 1 day
5.0 (5 reviews)
2.2
2.2
User Avatar
I can do it for you, You want help for modify a database that you already have, contact me in chat box so that we can discuss more about it in details. Thanks
$20 CAD in 7 days
3.7 (5 reviews)
2.4
2.4
User Avatar
Hello there, Myself Prakhar, I have read your description thoroughly and i am confident that i can do this easily. I can easily help you in changing your database schema according to your requirements Let's discuss further in personal chat. Regards Prakhar.
$40 CAD in 1 day
5.0 (3 reviews)
1.8
1.8
User Avatar
Hi there! I can update the tables and rows as per requirement. I have some really good experience in MySQL database and proved to be analytically strong. You can also visit my profile and read the previous employers' reviews to get a better understanding of my capabilities. Kindly contact me via chat so we can discuss the details. Thanks and Kind Regards, Farrukh Zaman Khan
$30 CAD in 1 day
5.0 (5 reviews)
1.4
1.4
User Avatar
=========I can Help you======I am MySQL Expert over 10 Year's. Please contact with me if still not choose anyone. Thanks.
$30 CAD in 1 day
2.0 (1 review)
0.8
0.8
User Avatar
I can help you with that. Let me know how much time limit you have for this. Secondly, being in alphabetical order or not is not a big deal. you can order them in you query. Thirdly, can you show me the screenshots of your tables? We can discuss it further if you wish so. Just let me know so that it may be fixed on ASAP basis. regards Farhan
$25 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hello. i am full-stack php developer. i am experience work in MYSQL database. i am read you description.i am helping your issue. thanks
$35 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Given an opportunity to be my first client here, I would like to assure you of timely and high quality result. I am an experienced software engineer with plenty of experiences working with Databases. Assuming that the data is static, and new data is not coming in real-time to the databases, your problem can be approached in two ways: 1) New Tables are parallel recreated to store correct data (Provinces, States). Eventually we simply switch to use new tables instead of old. This would be a breaking change and downtime would be needed if that database is currently used with another application. 2) We can create new mapping tables for Province to State mappings. A DB view can be simply created to combine the new table with existing data to give correct view. This change would be non-breaking and seamless. If there are no more applications reading from the old table, the old keys can be dumped at that point. I can write SQL queries to perform the operations. Some part of it would be manual (Providing the mappings). Additionally, If you expect new data coming into the DB still uses faulty keys, we can execute our queries as a stored procedure. Looking forward to hear from you. Best, Nishant
$15 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have knowledge of microsoft office like writing, editing power point and entering data to excel. I can do fast writing,entering and editing data with my own phone or laptop. Because i usually help my friends to help their job like you nedeed now. Thank you
$20 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a foreign key relationship in SQL. It will be quick and accurate. If interested, we can discuss this further on chat.
$30 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 5 years of experience programming SQL database; maybe a can review it and give you a solution. Relevant Skills and Experience I work developing a database, very apart I dedicate myself to the development of applications in the spring framework.
$15 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have experienced working in different database technologies for almost 12 years and i can fix this issue. Looking forward to work with you. Thanks.
$15 CAD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Chatham, Canada
5.0
25
Payment method verified
Member since Apr 6, 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.